Not equat to
 

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

Not equat to
 

=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

Not equat to
 

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

--
HTH

Bob

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

"srain001" wrote in message
...
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