Hi,

Instead of FIND(), you could use the SEARCH() function as well provided your
search is not case sensitive.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Glenn" wrote in message
...
Glenn wrote:
bashtherat wrote:
I used the following formula to count the number of times "NPRP served"
appears in a worksheet column: =COUNTIF(H3:H38,"*NPRP served*"); but it
stops counting if there is too much text before the target text appears.

Why does this happen and how do I get round it?

Please help.


Try this array formula (use CTRL+SHIFT+ENTER):

=COUNT(--(FIND("NPRP served",H3:H38)0))

And without the "0", the "--" also can be dropped, leaving you with this:

=COUNT(FIND("NPRP served",H3:H38))