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.


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

Excel Ebook Subscribe


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

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

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

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

  4. How does a formula like the following works ?
    What is the meaning of * in this formula ?



Leave a Comment