Not equat to

S

srain001

Hi

I'm wondering how I can write a formula which tells me when a cell contains
something that is NOT equal to a certain value.

For example, I would like to find out how many cells in Column A have values
other than CANADA.

Thanx
Srain
 
B

Bob Phillips

=COUNTIF(A:A,"<>CANADA")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top