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

--
Gary''s Student - gsnu200751


"srain001" wrote:

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