=SUMPRODUCT(--(NOT(ISNUMBER(MATCH(A1:A100,{"NEW","CLOSED","MONIT OR"},0)))))

--
HTH

Bob Phillips

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

"Uggywuggy" wrote in message
...
Ron/Bob

Ta. And if I want to count all rows but EXCLUDE those where the values are
New/Closed/Monitor can I use the '<' symbols ?



"Ron Coderre" wrote:

If you want to also skip blanks, try this:
=COUNTA(A1:A100)-SUM(COUNTIF(A1:A100,{"NEW","CLOSED","MONITOR"}))

Otherwise, to include blanks in the count:
=ROWS(A1:A100)-SUM(COUNTIF(A1:A100,{"NEW","CLOSED","MONITOR"}))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Uggywuggy" wrote:

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")