count their presence

H

hirendra7158

Hello!
I mark my students' presence as a p in date column.
in hte last column I want the total of the lectures that a student
attended.
meaning---total of the p s in previous columns.
can any body help me?
thanks in advance.
 
E

Elkar

Try this:

=COUNTIF(A2:Z2,"P")

This will count all the "P"s in row 2, columns A thru Z. Adjust the range
to fit your needs.

HTH,
Elkar
 
Top