count their presence
 

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.


--
hirendra7158
------------------------------------------------------------------------
hirendra7158's Profile: http://www.excelforum.com/member.php...o&userid=32399
View this thread: http://www.excelforum.com/showthread...hreadid=521881

count their presence
 

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


"hirendra7158" wrote:


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.


--
hirendra7158
------------------------------------------------------------------------
hirendra7158's Profile: http://www.excelforum.com/member.php...o&userid=32399
View this thread: http://www.excelforum.com/showthread...hreadid=521881