SUMPRODUCT(Array1, Array2...............)
- where, Array1, Array2......... - represents the arrays which first multiply and add.
Description
It returns the sum of multiplies corresponding values in the arrays.
Remarks
If Array1,Array2....... have different number of values, SUMPRODUCT returns the #ERROR.
Examples
Lets see an example in (Column3, Row1) =SUMPRODUCT(R1C1:R3C2,R4C1: R6C2) SUMPRODUCT returns 298.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 7 | 298 | |
| Row2 | 2 | 8 | ||
| Row3 | 3 | 9 | ||
| Row4 | 4 | 10 | ||
| Row5 | 5 | 11 | ||
| Row6 | 6 | 12 |