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