=SUMPRODUCT(--(A1:A100={"NEW","CLOSED","MONITOR"}))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Uggywuggy" wrote in message
...
I'm trying to count the number of rows where a cell DOESN't equal a number
of
values. I know this isn't the syntax but am looking for something as
follows;

i.e. COUNTIF(A1:A100,"<NEW", "<CLOSED", "<MONITOR")