Not equat to

[Guest]

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

 

[Guest]

=COUNTA(A:A)-COUNTIF(A:A,"Canada")

 

[Bob Phillips]

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

--
HTH

Bob

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