# How to Use Excel SUMPRODUCT Function (Examples + Video)

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

• The size of all the arrays must be the same.
• Non-numeric entries are treated as 0.

## Excel SUMPRODUCT Function – Video Tutorial

Related Excel Functions:

You May Also Like the Following Excel Tutorials:

FREE EXCEL BOOK

## Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

### 7 thoughts on “How to Use Excel SUMPRODUCT Function (Examples + Video)”

1. I have to construct a formula to solve a problem that has contraints. Will you help me if I send you the excel
Ramesh

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

3. Thanks a lot

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

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

6. This is all need