try this formula

Assuming you have a header row in row 1,
place this in B2 and copy down to as far as where your data in col A end.


=SUMPRODUCT(--(A2:A10<"blue")*--(A2:A10<"red")*--(A2:A10<"purple"))

Does this do waht you want?

HTH
--
======================
Pls click Yes if this has help you
======================

Thank You

cheers,





"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