Add and count
Count everything except one item
=COUNTIF(A2:A6,"<>North")How it works in Excel
- "<>" means "not equal to".
- It also counts blank cells inside the range.
- For a value in a cell, use "<>"&E2.
The idea in general
You count everything that fails the match.
What I assumed
- Your list is in A2:A6.
Check the result on your own data before relying on it.