Reply to thread

Message: [QUOTE="CGF2704, post: 14252702, member: 126787"] I have an employee schedule that lists the shifts worked on a weekly basis. The shifts are entered into the sheet using shift names rather than actual times. The hours (value) of each shift varies depending upon the number of movements in the day - on days with 3 movements most are 8, on days with 2 movements they vary from 5-8. I need for the last column of the schedule to show the total hours worked for each person, taking into account the difference in the daily schedule (movements). [ATTACH=full]9656[/ATTACH] Currently I'm using the following formula in column G [B]=SUM(COUNTIF(B4:E4,{"OKL","OAF","SECU","C","FC","SS1"})*{6,6,5,5,6,8}) [/B] However this doesn't take into account the difference between 2 & 3 movement days. I've tried various combinations of LOOKUP, VLOOKUP, IF, etc. but haven't been able to make work. Any thoughts from the pros? Thanks for the help! [/QUOTE]