Hey,

I'm trying to summarise month on month how many time a person is off sick or late. Currently we track our attendance on individual monthly sheets so I am looking at creating a summary page on a central sheet to link to the month sheets but cannot work out the best, and simplest formula for the task.

we have it set out as per the screen grab:

Capture.JPG

In one month there is a potential 24 selling days so for each agent there is 24 SIC columns to count so would a countif be the formula to use but how would it work given there is 24 columns?

thanks in advance.