Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Excel as a markbook for attendance and assessment
I'm using Excel to record and track my students' attendance and assessment.
I would like to know how to get Excel to count up the number of sessions students have attended class, so I can then get it to calculate the percentage of classes they've been present. I have been inputting attendance into columns by date, as P for Present and A for Absent (with other codes such as M for Medical). I need Excel to count up the number of Ps, but so far I can only get it to count the number of cells containing numbers rather than letter data. Can anyone help me? Many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Excel as a markbook for attendance and assessment
Try this:
=COUNTIF(C2:Y2,"P") assuming your attendance data is in columns C to Y - adjust as required. This will count the number of Ps in that range. Hope this helps. Pete On Apr 27, 9:35*pm, UniTeacher wrote: I'm using Excel to record and track my students' attendance and assessment. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ASSESSMENT FORMULA | Excel Worksheet Functions | |||
Assessment Worksheet | Excel Discussion (Misc queries) | |||
How do I set up a needs assessment result template in Excel? | Excel Worksheet Functions | |||
Excel Markbook Query | Excel Discussion (Misc queries) | |||
Capacity Assessment | Excel Discussion (Misc queries) |