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 •

#1
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:

=COUNTIF(A1:A12,"India")

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

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question