Posted to microsoft.public.excel.worksheet.functions

Toppers

external usenet poster

Posts: 4,339

How to write a count-if-not function?

Try:

=COUNTIF(A1:A5,"<*my phrase*")

HTH

"Jsatter" wrote:

I am trying to write a function that counts the the cells within a range that
do not include a certain phrase.

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
"COUNTU" function in Excel to count unique entries in a range	WayneL	Excel Worksheet Functions	20	September 19th 08 03:50 AM
Count function	J-Raz	Excel Worksheet Functions	2	February 12th 06 02:57 AM
... Count Function ... with any character ...	Dr. Darrell	Excel Discussion (Misc queries)	4	August 9th 05 10:00 PM
Count Function Help	Josh O.	Excel Worksheet Functions	4	July 29th 05 11:04 PM
Automatically up date time in a cell	Mark	Excel Discussion (Misc queries)	5	May 12th 05 12:26 AM

All times are GMT +1. The time now is 08:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us