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:
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.
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.
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.