Hi Everyone,

There is a post in this forum regarding the rolling attendance for employees by point system http://www.excelforum.com/excel-form...-calendar.html, I have almost the same situation but with little twist. Our company track employees attendance by point system, if an employee left early or tardy get 1/2 point and if absent got 1 point. but if they have perfect attendance during 90 days 1 point reduce from their total point. I used the following formula, its work perfectly but its making total point to zero, will someone help me to solve this issue. any help will be greatly appreciated.

=SUM((COUNTIFS(G15:EN15,"Tar",$G$14:$EN$14,">"&$B$8)/2),(COUNTIFS(G15:EN15,"=Abs",$G$14:$EN$14,">"&$B$8)),(COUNTIFS(G15:EN15,"=LE",$G$14:$EN$14,">"&$B$8)/2))




Attendance.jpg