SUMPRODUCT()
- Parameters are arrays whose values are to be multiplied and then added.
- SUMPRODUCT(), returns the sum of the products of corresponding array components.
Description
SUMPRODUCT()
- This function first multiplies the corresponding values in respective arrays and then adds the product values to display the result.
- Argument are the numbers to be multiplied and then added.
- Parameters should be of same dimensions, else Calci displays #N/A error message.
- Non-numeric values are considered zero (0).
Examples
| Array 1 | Array 1 | Array 2 | Array 2 | Array 3 | Array 3 |
| 1 | 4 | 7 | 7 | -1 | -4 |
| 2 | 5 | 8 | 8 | -2 | -5 |
| 3 | 6 | 9 | 9 | -3 | -6 |
=SUMPRODUCT(A2:B4,C2:D4) : Calculates SUMPRODUCT of Array1 and Array2 as ((1*7)+(2*8)+(3*9)+(4*7)+(5*8)+(6*9)).
Returns 172 as a result. =SUMPRODUCT(A2:B4,E2:F4) : Calculates SUMPRODUCT of Array1 and Array3 as
((1*-1)+(2*-2)+(3*-3)+(4*-4)+(5*-5)+(6*-6)). Returns -91 as a result. =SUMPRODUCT(A2:B4,C2:D4,E2:F4) : Calculates SUMPRODUCT of Array1, Array2 and Array3 as
((1*7*-1)+(2*8*-2)+(3*9*-3)+(4*7*-4)+(5*8*-5)+(6*9*-6)). Returns -756 as a result. =SUMPRODUCT([2,6],[1.5,-2]) : Calculates ((2*1.5)+(6*-2)). Returns -9 as a result.
Related Videos
See Also
References