Sponsored Link

Sponsored Link

Saturday, May 2, 2009


The SUMPRODUCT in MS Excel is useful when you want a multiple a set of values to another set of value. This formula is very useful in scenario when you want to calculate the total sales value or cost. Let's take look at syntax.

Syntax: SUMPRODUCT(array1, array2, array3....)


Set A Set B
a1 b1
a2 b2
a3 b3
a4 b4
. .
an bn

SUMPRODUCT({a1, a2, a3, a4...an}, {b1, b2, b3, b4...bn}) = a1 X b1+a2 X b2+a3 X b3+a4 X b4....an X bn

Click on image below to Enlarge


In the above example, we have describe an example to calculate Total sales value and Total Cost value. Also, I have enclosed the link with example of SUMPRODUCT formula.

Click here to download SUM Product Example

Kindly let me us know your comment about this post. Also, you can subscribe to this blog to receive latest update in your inbox. Click on the link below

Subscribe to blog via Email

We assure you knowledge, not SPAM!


Immer, Active in Online Dynasis Network said...

Nice Blog, Thanks for visiting my blog and I am so sorry for the late reply, you can download the template http://www.ziddu.com/download/4666262/ProductReviewsTemplate.rar.html

I got this template from template4u.com

Asha said...

hey this is a great help. thanks

Asha said...

Hey this is of great help. Thanks

Sarfaraz Ahmed said...

Your most welcome..!!! Keep visiting...

kumar said...


kumar said...

super help ,, its amazing thanks yaar

Post a Comment