Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

SUMPRODUCT

Multiply the corresponding value and sum in Excel
Returns the sum of the products of corresponding array components

Rational

Multiply the corresponding value and sum.

Description

The Excel SUMPRODUCT function returns a sum of the product of numbers together distributed in multiplies ranges or arrays. SUMPRODUCT is a sophisticated way to add various products.

Syntax

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

Parameters

array1 – The first range of cells or array to multiply then add together
array2 [optional] – The second range of cells or array to multiply

Return Value

Sum of products

Key Notes

  • The SUMPRODUCT function (sum the product) multiple values positioned in the same place in two or more ranges or array and sum those products together.
  • The SUMPRODUCT function accepts the same dimension in each array to perform.
  • Treat non-numeric numbers same as if they were zero or a blank cell.
  • Up to 255 ranges are allowed, and for meaningful employ, at least 2 arrays are required. In case the user selects only one cell range, the function return sum of chosen numbers just like the SUM function.

Example (Image above)
To multiply and add multiple columns we use SUMPRODUCT function like here we multiply each Quantity with Price and Discount and then add them. Formula =SUMPRODUCT(B7:B10,C7:C10,D7:D10) it return 43.3 (Total Discount).

 

Keep Reading Similar Functions:

Sum range of cells based on multiple criteria in Excel

SUMIFS

The SUMIFS function returns an addition of numerical as per multiple criteria based on the match of dates, numbers, and text against the reference.

Read More »
Sum range of cells based on the rule in Excel

SUMIF

The SUMIF function returns a sum of number based on given criteria, like =SUMIF({2;8;10;3;5},”>5″) add numbers that are only more than 5 and returns 18.

Read More »
To add multiple numbers in Excel

SUM

The SUM function returns a number after adding multiple numeric arguments together =SUM(5,10,15) the Excel add numbers together and returns 30.

Read More »