countif (problem: text, number)
 

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/

countif (problem: text, number)
 

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

countif (problem: text, number)
 

Chris,

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

HTH,
Bernie
MS Excel MVP

"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/