Countifs (and index match in it) for a horizontal payroll data

[muraterguden]

Hi everyone,

I have a payroll file with a vertical list of employees and horizontally expanding dates. Every 3 columns are dedicated to each day as Time in - Time Out - Worked hours....
As you will see in the sample file provided, i punch in the time in and time out and the last column of each day gives me the worked hours in hh:mm format.
But employees not always report to work and their absences also recorded with a TEXT into the Time In column for the day of absence.
I have an additional sheet where I check and count personnel's attendance for evaluation purposes. And here is the problem;
I use the text code CNC for "called not coming" and NCNS for "No Call No Show". I have managed to count all with a START and END date. But I want to add a fine detail to my evaluation and I want to count the CNCs and NCNSs occurred on Fridays and Saturdays only. And I could not make it work so far.
Not sure if I'm on the right path or play with INDEX MATCH as well...
The formula I need is in the ATT CHECK sheet and the column headed with "CNC on Fridays"...

Thanks in advance.

PS: here is the other post link;
https://www.mrexcel.com/forum/excel-...ml#post4937709

[AliGW]

You can post the question is as many forums as you like as long as you post links to those other forum threads here.