Excel Excel demographic data crunching

[emtsociology]

Hi I have been working on a project.
How to pull data from an array from one sheet that refrences another sheet in a drop down menu.
The list is countries of origin
I'm trying to pull names of countries and how many times that name shows up in multiple sheets.... to be compiled into a master sheet.

like drop down menu refrences sheet Africalist, southamericalist, asialist,
? how to list a country in a master sheet; and how many times it shows up?
Should I make a user form(just heard about these)
A macro?
A VRB?

I am volunteering for a refugee center here in Denver.

Thanks
Justin

 

[alow]

Welcome to the forums! I would suggest you start by trying out a COUNTIF formula. Just try the following:

=COUNTIF(Range,Criteria)

For the range, reference the cells in the sheet that you want to count instances of. For the criteria, reference the cell that has drop down. You can select these ranges and cells by clicking on the cells you want while you are in the formula.

That should get you started!