Is there an equivalent function?
You can use SUMPRODUCT() to sum
To sum c based on conditions in A and B
=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=D2),C1:C10)
If this post helps click Yes
---------------
Jacob Skaria
"Ayo" wrote:
I am trying to sum up a column base on the conditions in 2 other columns. I
know Excel 2007 has SUMIFS(), but I need something that is equivalent for
Excel 2003. I used SUMPRODUCT before, but that is just to count numbers based
on more than 2 conditions.
Most of the people that will be using this file still have Excel 2003, that
is why I need something compatable to 2003.
Any ideas?
Thanks.
|