SUMPRODUCT: The Function and 10 Different Formula

Sumproduct is a function that would multiply components that corresponds in a array. It would then return with the sum of all those products in the arrays.

Parameters and Arguments

The sumproduct has these following arguments, and look like this: sumproduct(array1; array2; array3; array4;… array255).

Array 1 – 255: These are the components that the user wants to multiply, and then add together.

Example 1: Simple Sumproduct Formula

We are acknowledging the sumproduct of the data that has been layout, and with regards to that, there is need for finding answers to the question. We are using the sumproduct formula to find the answers needed.

Simple Sumproduct Formula

Example 2: Complex SUMPRODUCT Formula

As we'd know sumproduct would return with the multiplications, and we'd have multiple data that we are trying to find the answers for, which is where we are using the sumproduct formula.

Complex SUMPRODUCT Formula

Example 3: SUMPRODUCT with Flexibilities

There is a percentages that has been layout, and we would like to know the percentage of the sumproduct. This is why we are inputting the percentages that have increased twice, which is why we need to add them.

SUMPRODUCT with Flexibilities

Example 4: SUMPRODUCT with Text

The whole data has been labeled with text, and we would need to find answer, which is why we needs to use that label to find the answer we need.


Example 5: SUMPRODUCT for Sales

We are using the sumproduct function to find answer for the product, which provides this result.


Example 6: SUMPRODUCT and Percentage

We are simultaneously using the sumproduct formulas to get appropriate result with the data we'd have at hand.

SUMPRODUCT and Percentage

Example 7: Sumproduct in Multiple Cells

We are finding the sumproduct of the data, and use it to get the result in multiple cells. This means, after writing the formula, we'd be pressing F2, followed by ctrl, shift and then press enter on the keyboard.

Sumproduct in Multiple Cells

Example 8: Double Sumproduct

There are two competing parties that are trying to get the price, and we are trying to find the winner. This is why we are using two sumproduct formulas to find the winner.

Double Sumproduct

Example 9: IF and SUMPRODUCT

We have the whole data layout in the spreadsheet, but we do not know how the situation is, and we would like to know if there is a specific number there.


Example 10: IF, SUM and SUMPRODUCT

Our situation is quite complex. We'd have a desire to find out our performance when the sum of a data is more than a specific amount. This is why we would need to use the IF, SUM and SUMPRODUCT formulas simultaneously to find the result.