Thanks so much but I just tried the formula and it gives me an incorrect total e.g. row 2 says 4 when it should be 3 (Employee3 + Employee5 + Employee8) and row 3 says 5 when it should be 3 (Employee3 + Employee5 + Employee8 + nobody on shift) etc. Any ideas?