BenBentley
New Member
- Joined
- Oct 21, 2002
- Messages
- 18
I have a range of data which consists of an employee ID and three other fields for a number of employees. I have this range for every day of the week but not every employee works everyday. The employees are split into teams and I need to sum the data for a whole team, not every team member works everyday. I am using vlookups to find the appropriate field for the correct day, but I cant sum these if a team member is not working that day because one or more of the vlookups returns a #N/A. I know I could use an IF(ISERROR(...) statement, but with up to 22 employees in a team then the formulas get rather large. I have tried a CSE formula but because the array containing team members and the array containing all employees working that day are not the same size I cant get it to work. Does any one have any bright ideas, other than having another table of data for each team?