| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Linear Mode
