Hi,

I have weekly attendance registers in individual worksheets that display
whether a person was "in", "sick", "u/a" or "hols" from Sun-Sat.

I have adapted a formula;

=SUMPRODUCT(COUNTIF(INDIRECT("'"&{"18 jan","25 jan"}&"'!b5:h5"),"hols"))

from these forums that works to a degree however, I have an issue with new
employees. I cannot find a way to update the sheet so that the new employee
can slot in alphabetically and not upset the above formula as he would then
take over the range of b5:h5 that is meant for someone else.

Any help would be greatly appreciated.

Thanks

Paul