Percentage computation for attendance.

[biggie]

Hello,

I'm having problems computing for the percentage for attendance especially if there are tardies. Kindly help. Here's my current formula.

=IF(ISERROR((COUNTIF(I10:AK10,"P")+COUNTIF(I10:AK10,">0"))/(COUNTA(I10:AK10)-COUNTIF(I10:AK10,"OFF")-COUNTIF(I10:AK10,"PVW")-COUNTIF(I10:AK10,"UVW"))),"",(COUNTIF(I10:AK10,"P")+COUNTIF(I10:AK10,">0"))/(COUNTA(I10:AK10)-COUNTIF(I10:AK10,"OFF")-COUNTIF(I10:AK10,"PVW")-COUNTIF(I10:AK10,"UVW")-COUNTIF(I10:AK10,"RDOT")-COUNTIF(I10:AK10,"OT")))

Regards
Biggie

 

[Dryver14]

Thats a lot of imput codes for attendance, I would suggest you find a single code for absence and then percentage that against a count of all the rest

 

[biggie]

Hello,

Thank you for your reply Sir Dryver14.

Yes as we have different codes for leaves, voluntary time out et. al. I'm now confused where to put on tardies. i need to put on the minutes that they were tardy and compute for the percentage as of now with my current formula it's not affecting the percentage though it should be as it's still adherence.

Regards,
Biggie.

 

[Dryver14]

i understand but lets say

inside
outside
course
full
ptm
hol

whilst there are many kinds of attendace,
I assume holidays count as attendance, that leaves 2 kinds of absence

late
absent

count those and percentage against the rest as a whole