| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
