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: –
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 firstname.lastname@example.org.
Lets see who gets it first 🙂
Whoever gets it, I will post that person’s name on the blog.