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.