How can I count nonblanks in column B only if
column A contains certain value?

What's the "certain value" in column A?

=SUMPRODUCT(--(A1:A10=10),--(B1:B10<""))

=SUMPRODUCT(--(A1:A10="some_text"),--(B1:B10<""))

Or, C1 = some value

=SUMPRODUCT(--(A1:A10=C1),--(B1:B10<""))

Biff

"cpy" wrote in message
...
How can I count nonblanks in column B only if column A contains certain
value?