SumIF with 2 critrtia

  • Thread starter Thread starter M.K
  • Start date Start date
M

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
 
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
 
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
 
I use office 2003
=SUMPRODUCT((L:L="abcd")*(M:M>0)*M:M)
Click to expand...

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)
 
Back
Top