tracking payroll by employee's first name

[losgatosmama]

Hello,

I have been wracking my brain on this one - hoping to find some help.

My goal is to calculate my total gross payroll costs each week as well as my payroll expenses by dept. I do not need to remove taxes or benefit expenses. I have 70 employees each with his/her own hourly rate and 4 different depts.

My depts are: Group exercise: general, Yoga, Pilates and Cycling.

What I would like to do is associate each employee's first name with his/her hourly rate.

And then, on Monday, for example, under my Yoga column enter the employee names who worked that day and then get a sum of the payroll expenses for the Yoga dept on that day.

So - how to I associate a person's name with an hourly rate? (is it using the
And then how do I set it up so that when I have individual cells containing for example, "Jon, Katie, Ben, Sally" -- the cell at the end of the row = $sum of their wages earned?

Thank you!!

[royUK]

First Name? Seems a bad choice, I would expect you will have employees with the same first name. Assign each employee an ID number

[losgatosmama]

Hello - Here's an example I threw together with some sample info.
Entering the first name is the best option in this case if there is a way to achieve what I want to do.
Thank you so much for taking a look. I appreciate the assistance.

[arthurbr]

Does the attached help?

( you can replace SUMPRODUCT with SUMIFS in XL2007)

[losgatosmama]

Thank you so much -- that works like a charm!
Hooray!

[arthurbr]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save