Track Employee Attendance

Hi Maabbas,

Sorry for late.

Do you meant, if there is no LE/ABS/TAR in last 90 days, then the employee should get 1 point minus from total point?

Your formula works perfectly fine I have just added IF condition see if it works and solve your purpose..

Formula:

=IF(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))=0,-1,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)))

Thanks,
Anil Dhawan