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`

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 |