Attendance list and lateness calculation

When you say 'And so on', how much is 6L and 7L worth, because I can see no logical sequence forming?

You say each Late is half a point, but then you say 3 Late is 1 point (instead of 1.5) and 5 is 4 points (instead of 2.5)

If half a point for each late, that's easy ;

= COUNTIF(Sheet1!$C3:$I3,"L")*0.5

Pretty similar to the ones you have for A & P:

Formula:

Please Login or Register  to view this content.

I provided that solution just based on "Each Late is 0.5 point" but as Croweater points out your examples for this don't make sense.

Originally Posted by janmorris

it would appear that the company wants you to ROUNDDOWN to zero decimal places

That might be, but it doesn't work for

5 L= 4 points

5 L would result in 2 points with a round-down approach. Actually it would only be 2.5 with exact figures so maybe "4" is a typo.

The increasing penalty points make sense - basically to warn latecomers to buck up immediately. Assuming 6L=5 and 7L=6,
formula:=CHOOSE(COUNTIF(Table1[@[Attendance 1]:[Attendance 7]],"L")+1,0,0.5,1,1,2,4,5,6).

0L=0
1L=1
2L=1
3L=1
4L=2
5L=4
6L=5
7L=6