Student Attendance Record

J

Jennifer

How do I set up an attendance record that calculates absences and tardies? A
continuous calculation would also be helpful
 
B

Bob Phillips

Put the student names in A2 down.

Put the dates in D1:xx1 (however many you want up to 253)

In D2:xx down enter A for absence, L for tardiness.

In B2 use =COUNTIF(D2:IV2,"A")
In C2 use =COUNTIF(D2:IV2,"L")

and copy these down.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top