Loading…
Loading…
SUMPRODUCT multiplies matching items and returns the sum of those products.
=SUMPRODUCT(array1, [array2], …)
| Argument | Required? | What it is |
|---|---|---|
| array1 | Required | The first range or array. |
| array2, … | Optional | A second range or array of the same size. |
Type the formula yourself and get it graded instantly, no Excel needed.