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

• Umesh says:

Thanks a lot

• Jawan singh says:

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

• Nik says:

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

• gatot ardianto says:

This is all need