countif formula with 2 critrtia

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
 
P

Per Jessen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SumIF with 2 critrtia 5
COUNTIFS with OR 5
Help with countifs 1
How to make string align by string.Format() in CJK? 4
dsum evaluating only the beginning of a string? 2
Query To Define Outstanding Issued Document 2
Totalling then Averaging subject to Product Code change 3
sum and count multiple conditions 2

Top