When to use Excel SUMPRODUCT Function
SUMPRODUCT function can be used when you want to first multiply two or more sets to arrays and then get its sum.
What it Returns
It returns a number that represents the sum of the product of two or more arrays.
Syntax
=SUMPRODUCT(array1, [array2], [array3], …)
Input Arguments
array1 – The first array argument whose components you want to multiply and then add. [array 2] – (optional) Second array arguments whose components you want to multiply and then add. There can be a maximum of up to 255 arrays that can be used in SUMPRODUCT function.
Additional Notes
The size of all the arrays must be the same. Non-numeric entries are treated as 0.
Excel SUMPRODUCT Function – Live Example
Excel SUMPRODUCT Function – Video Tutorial
Related Excel Functions:
Excel AVERAGE Function. Excel AVERAGEIF Function. Excel AVERAGEIFS Function. Excel SUM Function. Excel SUMIF Function. Excel SUMIFS Function.
How to Calculate Weighted Average in Excel.
=SUMPRODUCT((OFFSET($A8;0;1;1;372)””)(OFFSET($A$3;0;1;1;372))((OFFSET($A8;0;1;1;372))=NN$5))
