=Sumproduct(--isnumber(B1:B200),--(A1:A10075%))
Assume in your sample that 75% represents and actual number that is 75%,
and not the string literal "75%"
--
Regards,
Tom Ogilvy
"chrismania" wrote in message
...
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
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/