Student Attendance Record
 

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

Student Attendance Record
 

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)

"Jennifer" wrote in message
...
How do I set up an attendance record that calculates absences and tardies?
A
continuous calculation would also be helpful