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
|