How to write a count-if-not function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Cheers
Jo
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count range of cells if not next to each other 0
countif and sumif 3
count number of occurances between 2 values 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel - count if a number falls within an array in a column & add 3
Counting cells with conditional formatting 3
Count IF 1
Count Function 1

Back
Top