Posted to microsoft.public.excel.worksheet.functions

Patrick C. Simonds Patrick C. Simonds is offline

external usenet poster

Posts: 343

Countif question

I need to be able to check the range D19:AB19 for any occurrence of the
phrase On Call. That is easy enough with the formula below so my problem is
it could be entered as just On Call or On Call #1 or On Call #4 ect.

So what I need is something that will count the occurance of On Call or any
phrase containing On Call.

=COUNTIF(D19:AB19,"On Call")

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 question	Marline	Excel Discussion (Misc queries)	2	October 11th 07 09:59 PM
COUNTIF question	Cowtoon	Excel Worksheet Functions	7	January 5th 07 10:40 AM
CountIF Question	guile	Excel Worksheet Functions	1	January 26th 06 02:43 AM
Countif question	Jim	Excel Worksheet Functions	1	December 15th 05 12:32 PM
COUNTIF Question	zbert	Excel Worksheet Functions	2	October 31st 04 05:14 PM

All times are GMT +1. The time now is 06:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us