Posted to microsoft.public.excel.worksheet.functions

bashtherat bashtherat is offline

external usenet poster

Posts: 4

COUNTIF STOPS COUNTING

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF not counting properly	Christine	Excel Discussion (Misc queries)	4	October 23rd 08 08:21 PM
COUNTIF counting incorrectly	Dave	Excel Worksheet Functions	9	May 6th 08 10:02 PM
COUNTIF not counting	will b	Excel Discussion (Misc queries)	3	September 14th 07 05:50 PM
Countif and Text - not counting	karin	Excel Discussion (Misc queries)	1	October 18th 05 07:43 PM
Using COUNTIF for Counting Words?	Rich B	Excel Worksheet Functions	2	September 26th 05 08:40 PM

All times are GMT +1. The time now is 05:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us