Manuals/calci/SUMPRODUCT

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

SUMPRODUCT

See Also

References