Manuals/calci/SUMPRODUCT

SUMPRODUCT(arr1, arr2, .....)

• where $arr1,arr2,.....$ are arrays whose values are to be multiplied and then added.

SUMPRODUCT() multiplies the corresponding array values and displays their sum as a result.

Description

SUMPRODUCT(arr1, arr2, .....)

• This function first multiplies the corresponding values in respective arrays and then adds the product values to display the result.
• Argument $arr1,arr2,.....$ are the numbers to be multiplied and then added.
• $arr1,arr2,.....$ 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 ((1*7)+(2*8)+(3*9)+(4*7)+(5*8)+(6*9)). 
Returns 172 as a result.
=SUMPRODUCT(A2:B4,E2:F4) : Calculates ((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 ((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 -3 as a result.

See Also

• SUM
• PRODUCT

References

• Product
• Summation