COUNT IF COLUMN X="" COUNT COLUMN Y?

COUNT IF COLUMN X="" COUNT COLUMN Y?

Post by VG9tIEhld2 » Fri, 04 Mar 2005 19:59:02


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
 
 
 

COUNT IF COLUMN X="" COUNT COLUMN Y?

Post by Bob Philli » Fri, 04 Mar 2005 20:20:42

=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)




A