Using Excel as a markbook for attendance and assessment

  • Thread starter Thread starter UniTeacher
  • Start date Start date
U

UniTeacher

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
 
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
 
Back
Top