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.