Using Excel as a markbook for attendance and assessment

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
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating an attendance sheet EXCEL 0
using excel as a markbook 1
Help with Iif on Report 4
ATTENDANCE SPREADSHEET 5
Attendance Spreadsheet 1
Autonumber field in Excel that behaves the same as Access 0
attendance with sorting 4
Use Workbook tabs in a Worksheet 1

Top