SumIF with 2 critrtia

[M.K]

Hi

Hiw i do sumif formula with 2 critrtia for example

A:A = ABCD
B:B > 0

so the resule will be sum of B:B if A:A =ABCD & B:B >0 for example

ABCD 2
FGHI -3
ABCD -5
ABCD 4
FGHI 2

the result with matich with critria 2 + 4 = 6

 

[Don Guillett]

=SUMPRODUCT((L1:L21="abcd")*(M1:M21>0)*M1:M21)

 

[AdamV]

If you have Excel 2007, simply use SUMIFS (note the S on the end).
If not, construct a SUMPRODUCT instead.

Confirm which version you have and we can probably help in more detail

 

[M.K]

Thank you all for reply

I use office 2003

when i use the SUMPRODUCT as following it's not work

=SUMPRODUCT((L:L="abcd")*(M:M>0)*M:M)

any one can help me more

 

[Don Guillett]

You can NOT use entire columns. Look at my post again.

 

[T. Valko]

I use office 2003

=SUMPRODUCT((L:L="abcd")*(M:M>0)*M:M)

You can't use entire columns as range references in SUMPRODUCT unless you're
using Excel 2007 or newer. Use specific ranges.

=SUMPRODUCT(--(L1:L100="abcd"),--(M1:M100>0),M1:M100)