count all text values except a certain one

  • Thread starter Thread starter justjill111
  • Start date Start date
J

justjill111

if i have the word 'ditto' scattered among a bunch of names (text), how do i
count every value that's not 'ditto' ? am i trying to combine "COUNTIF"
value with "NOT" criterion...?
 
One thought ..
Assuming your source data running down in col A
you could use this in say, B1:
=COUNTA(A:A)-COUNTIF(A:A,"*"&"ditto"&"*")
voila? zonk YES below
 
Try this...

=COUNTIF(A1:A10,"<>ditto")

The <> operator means "not equal to". I find it easier to think of it as
meaning "is not".

Note that will count empty cells.
 
sorry but it returned the entire count. let me be more specific.
the names are contained E7:E98 the column looks something like this:

jane
max
ditto
ditto
ditto
laurie
kelly
dittto

does this help?
 
in other works, for the below example, how do i get a count of 4 instead of 8?

justjill111 said:
sorry but it returned the entire count. let me be more specific.
the names are contained E7:E98 the column looks something like this:

jane
max
ditto
ditto
ditto
laurie
kelly
ditto

does this help?
Click to expand...
 
sorry max, your formula was perfect, i just didn't realize it in time to
avoid making a fool of myself ~!~

justjill111 said:
in other works, for the below example, how do i get a count of 4 instead of 8?
Click to expand...
 
Back
Top