As I mentioned the other day, SUMPRODUCT is very powerful. If you looked at the earlier blog, you saw its original or basic use -Multiplying corresponding values in columns and then summing them. If you skipped that blog, you may want to go back and take a look at it first.
With SUMPRODUCT, you can do much more. There is an interesting discussion that explains in great detail how SumProduct works in case you are interested. http://www.xldynamic.com/source/xld.SUMPRODUCT.html
It is so good, that I don't want to repeat it but will just walk through an example.
First- Using the example on the left, I can use it to add up all the Items Sold if the Cost per Item is equal to 2.
The resulting answer is 2875. Reminds you of SumIF doesn't it?
Now, for those of you still using Excel 2003, yes- the good news is that you can have multiple conditions. However, there is a twist to the syntax so it is a bit different.
To add up all the Items Sold if the Cost per Item is equal to 2 or equal to 1 you would use the following formula.