COUNTIF STOPS COUNTING
Your solution did not work.
I am running windows xp with office 2003 and the text box contains more than
255 characters.
"Glenn" wrote:
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))
|