Need a formula to count the number of cells that don't equal a specific value

[Hayley]

I have a column of cells that either say "new", have a number in them (numbers differ), or are blank. I used =countif(a2:a22540,"new") to count how many are new. If I want to count how many are not "new", what's the formula for that?

 

[oldchippy]

Hi,


Try this one


=COUNTIF(A2:A22540,"<>"&"new")