|How do I use countif for items in a group?|
I would like to count how many times the countries in a region appears in a range. I have a table with each region and a list of countries in each country.
The range I would like to get a count for lists the countries on (not the region).
How do I use my region/country table to count the number of times a country in the region appears in the range?