SUMPRODUCT function
Summary
Returns the sum of the products of corresponding array components
Syntax
To use the default operation (multiplication):
=SUMPRODUCT(array1, [array2], [array3], ...)
The SUMPRODUCT function syntax has the following arguments:
array1 Required | The first array argument whose components you want to multiply and then add.
[array2], [array3],... Optional | Array arguments 2 to 255 whose components you want to multiply and then add.
To perform other arithmetic operations
Use SUMPRODUCT as usual, but replace the commas separating the array arguments with the arithmetic operators you want (*, /, +, -). After all the operations are performed, the results are summed as usual.
Note: If you use arithmetic operators, consider enclosing your array arguments in parentheses, and using parentheses to group the array arguments to control the order of arithmetic operations.
The SUMPRODUCT function syntax has the following arguments:
array1 Required | The first array argument whose components you want to multiply and then add.
[array2], [array3],... Optional | Array arguments 2 to 255 whose components you want to multiply and then add.
To perform other arithmetic operations
Use SUMPRODUCT as usual, but replace the commas separating the array arguments with the arithmetic operators you want (*, /, +, -). After all the operations are performed, the results are summed as usual.
Note: If you use arithmetic operators, consider enclosing your array arguments in parentheses, and using parentheses to group the array arguments to control the order of arithmetic operations.
Example
=SUMPRODUCT(C2:C5,D2:D5)
=C2*D2+C3*D3+C4*D4+C5*D5 and press Enter. After pressing Enter, the result is the same: $78.97. Cell C2 is multiplied by D2, and its result is added to the result of cell C3 times cell D3 and so on.
=C2*D2+C3*D3+C4*D4+C5*D5 and press Enter. After pressing Enter, the result is the same: $78.97. Cell C2 is multiplied by D2, and its result is added to the result of cell C3 times cell D3 and so on.