## 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

Comments are closed.