SUMPRODUCT function
SUMPRODUCT multiplies corresponding elements in the given arrays, and returns the sum of those products.
Syntax
SUMPRODUCT (array1,array2,...array30)
array1, array2, ...array30 represent arrays whose corresponding elements are to be multiplied.
At least one array must be part of the argument list. If only one array is given, all array elements are summed.
Example
=SUMPRODUCT(A1:D1,A2:D2,A3:D3) returns 158
where
Array A1:D1 is the number of units sold
Array A2:D2 is the price per unit
Array A3:D3 is the percent reduction taken.
In each column, SUMPRODUCT multiplies units sold by price by reduction taken, and then adds the four products.
A | B | C | D | |
---|---|---|---|---|
1 | 2 | 5 | 1 | 0 |
2 | $5.00 | $20.00 | $100.00 | $1.00 |
3 | .80 | .50 | 1.00 | .90 |