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!!