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