Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Student Attendance Record
How do I set up an attendance record that calculates absences and tardies? A
continuous calculation would also be helpful |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Student Attendance Record | Excel Discussion (Misc queries) | |||
Student Attendance Record Template | Excel Discussion (Misc queries) | |||
How to repair 2005-2006 student attendance record? | Excel Worksheet Functions | |||
Using Student Attendance Record template in Excel 2003 | Excel Worksheet Functions | |||
How do I change dates in student attendance? | Excel Worksheet Functions |