Attendance Tracker with point system

Please help.

I am trying to make an attendance tracker for each month in the year for all colleagues on my team. I have created the excel file and made most of the calculations I need but want to make it to where we can put a letter in for the type of occurrence that (Tardy, Leave Early, Etc.) I have created a table in the Employees names tab to represent what each excuse is valued at. What I am looking for is that if i put in T for a day in January I want the totals to add up automatically based on the values assigned to the letters. I currently only have it to calculate the number value for each day and am pretty sure I could make some countif cells separate each type of excuse then add the totals, but I am struggling trying to figure this out. I have attached a copy of what i am looking for and would appreciate any help that anyone can give. I may have messed some things up while playing with this but hoping you guys can see what I am looking to achieve.


Colleague Attendance Calendar.xlsx

With month in E1 and Absent Types in row 3 of EmployeeName Table,
C4: =COUNTIF(INDEX(INDIRECT($E$1&"[[1]:[Total days]]"),MATCH([@[Employee Names]],INDIRECT($E$1&"[Employee name]"),0),),C$3), copy across and down.