How to Use Excel SUMPRODUCT Function (Examples + Video)

Excel SUMPRODUCT Function (Example + Video)

Excel SUMPRODUCT Function

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:

You May Also Like the Following Excel Tutorials:

  • 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

  • >