Excel - Calculating # of people per job title [Closed]

Report
Posts
1
Registration date
Friday August 10, 2012
Status
Member
Last seen
August 10, 2012
-
Hello,

I have a list of employees and all of the pay types that have been paid to them over the year, and their job title.

i.e.

Joe s Mechanic Reg hrly
Joe s Mechanic OT 1.5x
Joe s Mechanic OT 2x
Joe s Mechanic Stat

Kya m Mechanic Reg hrly
Kya m Mechanic OT 1.5x
Kya m Mechanic OT 2x
Kya m Mechanic Stat

Susie N Operator Reg Hrly
Susie N Operator OT 1.5x
Susie N Operator OT 2x
Susie N Operator Stat

John B Electrician Reg Hrly
John B Electrician OT 1.5x
John B Electrician OT 2x
John B Electrician Stat
John B Electrician Call-in
John B Electrician Banked $ pd


I have a pivot table summarizing the totals per pay type, by job title, and that is working fine. What I need to do is calculate how many individuals there are per title.

i.e.

Mechanic - 2
Operator - 1
Electrician - 1




Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!