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, etc. are the values in the array below
Example
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 sum product.
Calculate the sum product using the formula above.
FAQ
What is a sum product?
A sum product is a function in excel used to add the products of an array of numbers.