Hi
Do you want to count cells with "blue","green" and "purple"?
From what I gather, you do NOT want to count cells with these.

The formula that I have provide does NOT count cells with these texts.


--

cheers,






"Dax Arroway" wrote:

This actually doesn't work because I'm guessing that some of the cells in the
array (A2:A20) are populated by another sheet and some of the values are not
there yet (displayed as #NA).

The other "counters" I've got count the blues, purples, etc. and I'm looking
for a formulat that "Counts everything else except those I already counted."

My other counters a =Count(A2:A20, "blue") which works great! But
getting it to NOT count 3 different things, is the hard part.
"xlmate" wrote:

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