Suppose you have a list of values as this: –

You want to count all values except “d”. Normal =COUNTA will include all values.
But you can NOT count any 1 value (eg – “d”) using this formula: –

=COUNTIF(A1:A11,”<>d”)

QUESTION: –
What if you want to count all values except “c” and “d” both?
Try this out yourselves.
If you get it, send your answer to me on rjs1212@gmail.com.
Lets see who gets it first 🙂
Whoever gets it, I will post that person’s name on the blog.