COUNT IF COLUMN X="" COUNT COLUMN Y?

T

Tom Hewitt

Hi

really simple one.

I need a formula that will count if coumn B is greater than 0, when column A
= a certain field of text.

Thanks for your help
 
B

Bob Phillips

=SUMPRODUCT(--(B1:B1000>0),--(A1:A1000="text"))

SP cannot work on a whole column so you have to nominate the range.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top