FormuladrillSUMPRODUCT practice
SUMPRODUCT multiplies matching values in two or more ranges and adds the results. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.
Syntax
SUMPRODUCT(array1, [array2], ...)
What people get wrong
Price times quantity for a whole order in one formula, and a weighted average when divided by the total weight.
Excel exercise that use SUMPRODUCT
- Portfolio returnLevel 5Pro
Practice SUMPRODUCT now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free