count all text values except a certain one

[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...?

 

[Max]

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

 

[T. Valko]

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.

 

[justjill111]

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?

 

[justjill111]

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

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?

 

[justjill111]

sorry max, your formula was perfect, i just didn't realize it in time to
avoid making a fool of myself ~!~

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