Excel Functions

Excel SUMPRODUCT Function

Pinterest LinkedIn Tumblr

The Excel SUMPRODUCT is categorized under Math & Trignomentry functions. SUMPRODUCT function multiplies the arrays and returns the sum of products. By default Excel operation is multiplication but addition, subtraction, and division are also possible. SUMPRODUCT can also be used as a substitute to COUNTIFS or SUMIFS, with more feasibility. To increase or extend the functionality of any function it can be used inside SUMPRODUCT.

Purpose of Excel SUMPRODUCT Function

To multiply and the sum arrays.

Return value

SUMPRODUCT function returns the result of multiplied and summed arrays.

Syntax

= SUMPRODUCT(array1, [array2], [array3], …)

Arguments

ArgumentsDescriptionRemarks
array1The first array argument whose components you want to multiply and then add. Mandatory
[array2] Array arguments 2 to 255 whose components you want to multiply and then add. Optional
[array3]Array arguments 2 to 255 whose components you want to multiply and then add. Optional

Usage notes

  • The array arguments should have the same dimensions else, SUMPRODUCT returns the #VALUE! error value. For example, =SUMPRODUCT(C2:C10,D2:D5) will return an error since the ranges aren’t the same size.
  • SUMPRODUCT treats non-numeric array entries as if they were zeros.

Availability

Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment