| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
