countif formula with 2 critrtia

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

M.K

Hi

howi do countif 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
ABCD 9

the result which matich with 2 critria = 3
 
Hi

If you are using excel 2007, you can use COUNTIFS, else you have to use
SumProduct:

SUMPRODUCT(--(A1:A10="ABCD"),--(B1:B10>0))

Regards,
Per
 
Back
Top