Enter the value of up to 5 pairs of numbers to calculate the sum product of those numbers.
Sum Product Formula
The following formula is used to calculate the sum product of an array of numbers.
SP = X*Y + W*Z+ A*B + C*D + E*F
- Where SP is the sum product of the table below
- X,Y, ect. are the values in the array below
How to calculate a sum product?
- First, determine the values and their pairs.
Determine the values and their pairs as displayed in the image above.
- Next, determine the sumproduct.
Calculate the sumproduct using the formula above.
A sumproduct is a function in excel used to add the products of an array of numbers.