Help with Totals using VLOOKUP/SUMIF for employee timetables.

UPDATE.

Just realised that the Data Validation didn't include the SICK HOL DUTY shifts etc, so have updated the validation to A:A rather than A6:...