A formula that gives the Days Due is:
=SUMIFS(tblEmployees[Total Days],tblEmployees[List of Employees],valSelEmployee)-T26-AB26-AR26
Here is a copy of your file with the formula applied: Copy of EmployeeAttendanceTest.xlsx
Let me know if you have any questions.