Survey data

jaba

New Member
Joined
Mar 1, 2005
Messages
1
I have conducted a survey and need to compute certain data recieved. I need to count the number of male and females which answered my survey, only this data needs to be seperated into age groups <20, 20 to 30, 30 to 40 etc. i.e. Number of Males <20 which took part.

I have seperated this data into three sections

age male female

Any suggestions?

The next thing which I have to do is then compare the answers recieved, numbered one to nine, into male and female totals. I have a fourth section which containe the answer. i.e. Number of females which answered 1.

Any help would be much appreciated.
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

scrupul0us

Well-known Member
Joined
Sep 7, 2004
Messages
641
could give countif a try and pass age ranges to it...

seeing some data and your setup could be helpful
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
Sounds like a pivot table may be the answer to your prayers.

Post some data if you need help
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,327
Members
414,053
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top