Thread: How to write a count-if-not function?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default 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 QuoteReply With Quote