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?

  1. First, determine the values and their pairs.

    Determine the values and their pairs as displayed in the image above.

  2. 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.

sum product calculator