G Guest Nov 1, 2007 #1 How do I set up an attendance record that calculates absences and tardies? A continuous calculation would also be helpful
How do I set up an attendance record that calculates absences and tardies? A continuous calculation would also be helpful
B Bob Phillips Nov 1, 2007 #2 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)
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)
