Use SUMPRODUCT to sum the product of corresponding values in cell ranges

SUMPRODUCT uses cell ranges as its arguments (the parts of the formula that make it work). It multiplies the items in the cell ranges, and then sums up the result.

To create the formula using our sample grocery list, type =SUMPRODUCT(B2:B5,C2:C5) and press Enter. Each cell in column B is multiplied by its corresponding cell in the same row in column C, and the results are added up. The total amount for the groceries is $21.60.

Sample grocery list to show how to use SUMPRODUCT

To write a longer formula that gives you the same result, type =B2*C2+B3*C3+B4*C4+B5*C5 and press Enter. After pressing Enter, the result is the same: $21.60. Cell B2 is multiplied by C2, and its result is added to the result of cell B3 times cell C3 and so on. You can imagine, if you have hundreds (or even thousands) of rows, how much easier using SUMPRODUCT would be.


  • The columns or rows must be of equal length.

  • If text, instead of a number, is in a cell, it’s treated as zero.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.