Excel Excel demographic data crunching


Joined
Jan 11, 2013
Messages
1
Reaction score
0
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:confused:
 
Ad

Advertisements

Joined
Mar 20, 2012
Messages
764
Reaction score
4
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top