Is there an equivalent function?

[Ayo]

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.

 

[Bernie Deitrick]

Ayo,

In general:

= SUMPRODUCT((Range1=Cond1)*(Range2=Cond2)*(Range3))

where Range 3 has the numbers to sum.

Each of the ranges must have the same number of rows or columns.

HTH,
Bernie
MS Excel MVP

 

[Jacob Skaria]

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

 

[Ayo]

Thanks Bernie.

Ayo,

In general:

= SUMPRODUCT((Range1=Cond1)*(Range2=Cond2)*(Range3))

where Range 3 has the numbers to sum.

Each of the ranges must have the same number of rows or columns.

HTH,
Bernie
MS Excel MVP

 

[Ayo]

Thanks Jacob.

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