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

## 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 sumproduct.**Calculate the sumproduct using the formula above.

## FAQ

**What is a sumproduct?**

A sumproduct is a function in excel used to add the products of an array of numbers.