Manuals/calci/SUMPRODUCT
Jump to navigation
Jump to search
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 |