Hi all,
I need to calculate the sum of an employee's hours worked during a given date range. I've attached an example of what I am working with. Shifts for all employees are on the first tab. Every time the name "Rose" appears during a week on the first tab I need it to add those hours together on the second tab. I know there's a formula to do this and I just can't quite get there. Thanks in advance for any help!
Sample.xlsx
Last edited by rockytop80; 12-14-2011 at 11:43 AM.
I meant to get to this sooner. Sorry for the delay.
You can use this formula in cell B2 of the Winter Instructors tab. Use it to autofill down and across your table.
I've also attached a copy with the function already populated across the cells.
Please Login or Register to view this content.
Brilliant, that's exactly what I needed!
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks