SUMPRODUCT()

Syntax. SUMPRODUCT(array1,array2,array3,...)

Definition. This function multiplies the matching components of the indicated arrays and returns the sum of these products.

Arguments

  • array1 and array2 (required) and array3 (optional) At least two and up to 255 components of arrays (30 in Excel 2003 and earlier versions) that you want to multiply and add.

Background. For a sum product, the values in an array are multiplied and the results are added. The formula is:

a1 b1

a2 b2 = (a1 · b1 + a2 · b2 + a3 · b3)

a3 b3

For example, you can calculate the total price of the products listed in a table.

The array arguments must have the same number of rows and columns. If they do not, the SUMPRODUCT() function returns the #VALUE! error. SUMPRODUCT() treats ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial