COUNT IF COLUMN X="" COUNT COLUMN Y?
 

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

=SUMPRODUCT(--(B1:B10000),--(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)


"Tom Hewitt" wrote in message
...
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