demographic analysis

katag

New Member
Joined
Apr 4, 2011
Messages
1
Hi,

I have an overview of all employees and their age in the company. I want to count how many employees are for example in the interval 20-24, 25-29, 30-34 etc. Is there a forumula to do it? Can it be done in a pivot table?

katag
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
Welcome to MrExcel!

The answer to both your questions is 'Yes'.

Formula
Formula in F2 copied down.


Pivot Table
Create Pivot table with Age as Row labels and Name in the Value area then right click in the Age column and choose 'Group...' and group by 5's. Result shown in columns H:I


Excel Workbook
ABCDEFGHIJ
1NameAgeAge RangesCountRow LabelsCount of Name
2Name 1212024420-244
3Name 2332529225-292
4Name 3243034530-345
5Name 426Grand Total11
6Name 530
7Name 633
8Name 734
9Name 821
10Name 925
11Name 1033
12Name 1124
13
Age ranges
 

scottylad2

Well-known Member
Joined
Feb 2, 2009
Messages
1,919
Frequency will also do as you need. the 95 as the upper age would count everyone who is older than your upper age limi

Excel Workbook
GH
37200
38244
39292
40345
41950
Sheet3


<table border="0" cellpadding="0" cellspacing="0" width="128"><col style="width:48pt" span="2" width="64"> <tr style="height:14.4pt" height="19"> <td class="xl63" style="height:14.4pt;width:48pt" height="19" width="64">
</td><td class="xl64" style="border-left:none;width:48pt" align="right" width="64">
</td></tr><tr style="height:14.4pt" height="19"><td class="xl63" style="height:14.4pt;border-top:none; width:48pt" height="19" width="64">
</td><td class="xl64" style="border-top:none;border-left:none" align="right">
</td></tr><tr style="height:14.4pt" height="19"><td class="xl63" style="height:14.4pt;border-top:none; width:48pt" height="19" width="64">
</td><td class="xl64" style="border-top:none;border-left:none" align="right">
</td></tr><tr style="height:14.4pt" height="19"><td class="xl63" style="height:14.4pt;border-top:none; width:48pt" height="19" width="64">
</td><td class="xl64" style="border-top:none;border-left:none" align="right">
</td></tr><tr style="height:14.4pt" height="19"><td class="xl65" style="height:14.4pt; border-top:none;width:48pt" align="right" height="19" width="64">
</td><td class="xl64" style="border-top:none;border-left:none" align="right">
</td> </tr> </table>
 

Watch MrExcel Video

Forum statistics

Threads
1,122,914
Messages
5,598,840
Members
414,261
Latest member
KatieBsc

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