How to write a count-if-not function?
 

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

How to write a count-if-not function?
 

Jsatter,

Take a look at the IS Functions in Excel, I am sure there is something
here that will help

Cheers
Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=562103

How to write a count-if-not function?
 

the quickest way to achieve what you're after is to use the FIND
function to search the text, which will return an error if it can't
find the relevant text. You can then use the ISERROR function with a
'--' infront to return ones and zeros which you can simply add up. You
will need to enter this as an array formula (hold ctrl+shift whilst
pressing enter).

So an example might be:

=SUM(--ISERROR(FIND("foobar",A1:A5)))


Rob




Jon Quixley wrote:
Jsatter,

Take a look at the IS Functions in Excel, I am sure there is something
here that will help

Cheers
Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=562103

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.