zmellender
New Member
- Joined
- Jan 10, 2015
- Messages
- 1
I'm trying to add a sum function to an attendance tracking workbook. I want the sum to be 5 different totals per person on a monthly basis for one year. Right now, there is a total per person at the end of each month, which is one sheet for each month. I want to pull the total absences, tardies, and three other numbers for each employee at the end of the month, so that I have their annual attendance in five categories. My issue is creating a name parameter. Each employee's name is in cell 'a', from anywhere from 2-62, to 2-203 on different sheets, as our workforce fluctuates wildly. I want the information in cells 'ag'-'ak' to be pulled based on the name contained in cell a. How do I do this so that I don't have to manually change each monthly spreadsheet when I add or delete dozens of staff? I've tried SUMIFS, to no luck. The name parameter is the only part I can't figure out. I'm using Excel 2010 on XP. Thank you for any help you can provide!