Countif Function "75%"
 

Hi Guys,
I want to count cells which contain the text "75%".
The problem is that Excel does not recognise it as a text (also after
having changed the format)It counts only values above 75% if you enter
this formel:
countif(A1:A10,"75%").
But I want to count the cells with "75%".
Thanks in advance



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Countif Function "75%"
 

This may help:

=SUMPRODUCT((A1:A10="75%")*1)

--
Jim Rech
Excel MVP

Countif Function "75%"
 

=COUNTIF(A1:A10,"*75%*")

if you are looking for the text string "75%"

--
Regards,
Tom Ogilvy

"chrismania" wrote in message
...
Hi Guys,
I want to count cells which contain the text "75%".
The problem is that Excel does not recognise it as a text (also after
having changed the format)It counts only values above 75% if you enter
this formel:
countif(A1:A10,"75%").
But I want to count the cells with "75%".
Thanks in advance



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/