View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dax Arroway Dax Arroway is offline
external usenet poster
 
Posts: 70
Default CountIf Not Multiple

Isn't there a way of counting everything BUT thing1, thing2, and thing3?

"Dax Arroway" wrote:

I'm trying to count a column that doesn't match a few selections. For
example, I want to count all cells in column A which doesn't contain blue,
green, or purple.

So my formula would be something like:
=CountIf(A1:A20, <blue or green or purple)

Any help please?
Thanks in advance!
--Dax