countif (problem: text, number)

[chrismania]

Hi guys
I have the following problem:
A B

75% 2 <75% Text
75% Text

I want to count the numbers in column B if the percentage is >75%.

In this case it would be 1

Thanks Chris

 

[Tom Ogilvy]

=Sumproduct(--isnumber(B1:B200),--(A1:A100>75%))

Assume in your sample that >75% represents and actual number that is >75%,
and not the string literal ">75%"

 

[Bernie Deitrick]

Chris,

=SUMPRODUCT((A1:A3=A1)*ISNUMBER(B1:B3))

HTH,
Bernie
MS Excel MVP