SUMPRODUCT multiplies corresponding elements in the given arrays, and returns the sum of those products.


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.


=SUMPRODUCT(A1:D1,A2:D2,A3:D3) returns 158


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.

Table 1. SUMPRODUCT example
  A B C D
1 2 5 1 0
2 $5.00 $20.00 $100.00 $1.00
3 .80 .50 1.00 .90