Every month I have to compile a count of all countries received that month. Specific countries are counted individually for occurences, and the rest goes into a count for “other”.

For example I might receive a list of countries as such:
“my, my, ch, de, de, fr, fi, ch, fr, fr, gb, fr, fr, sg, sg, sg, my, gr, es, it, nl, gb, at, us, at, ie, pt, my, gr, ru, ru”

where cn, my, de, sg, are counted in their own individual rows,

and anything that isn’t cn, my, de, or sg are counted as other.

I have set up countif for the individual countries counted, however how do I get a count of the countries that are not the ones already counted?

I have tried countif <> to exclude cn, my, de, sg however I keep getting an error message. I also tried doing a COUNTA for the whole list, and then tried to deduct the countries that are NOT other, but would still get an error message. I’m not sure how to set up the formula.