Solved Countif for a series of items in Excel

August 28, 2015 at 13:53:22
Specs: Windows 7
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?

See More: Countif for a series of items in Excel

Report •

August 28, 2015 at 14:38:31
✔ Best Answer
Without knowing how your data is arraigned, Column Letters & Row Numbers,
the best I can offer is something like:

With your Region data in A1 - A12
you can find how many times India appears with:


Also, Excel questions are best asked in the Office Software Forum.


Report •
Related Solutions

Ask Question