count their presence

  • Thread starter Thread starter hirendra7158
  • Start date Start date
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.
 
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
 

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

please help me mark their presence. 3
Marking cell; totaling all # between marked cell & next marked cel 4
Adding cels in a row that correspond to the heading of a column 2
How to finding student Rank and How to upload bulk marks of each student at a time. 1
sumproduct with 4 conditions 1
COUNT and SUM 5
help with If functoin 1
presence and absence 5

Back
Top