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