Excel SUMPRODUCT Function (Example + Video)
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.
You May Also Like the Following Excel Tutorials:
7 thoughts on “How to Use Excel SUMPRODUCT Function (Examples + Video)”
I have to construct a formula to solve a problem that has contraints. Will you help me if I send you the excel
Ramesh
i have to add everyday some quantity in a particular cell say today its 50 tomorrow i have to add 50 in the same cell more,i should not write 100 and same way also minus the value. the balance should be in one different particular cell in a proper way.
Thanks a lot
I have a multiple range like 1to 100 ,100 to 200 in column in one sheet & find out single no. Which are in others sheet like 50 is first range & 150 is in second range
How does a formula like the following works ?
What is the meaning of * in this formula ?
=SUMPRODUCT((OFFSET($A8;0;1;1;372)””)*(OFFSET($A$3;0;1;1;372))*((OFFSET($A8;0;1;1;372))=NN$5))
* MEANING ALL
This is all need