Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a column that has X if attended class then I need a sum of the number
of students that attended on that column. What is the easiest way to do this without having to use the number 1 for attendance? so, issue is sum any X in a column and total at the bottom. Thank you. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=COUNTIF(A1:A20,"X")
"shamor" wrote: I have a column that has X if attended class then I need a sum of the number of students that attended on that column. What is the easiest way to do this without having to use the number 1 for attendance? so, issue is sum any X in a column and total at the bottom. Thank you. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If x's are the only data in the column... you don't put anything if they did
not attend... then you can just count the cells that contain data: =COUNTA(E2:E21) "shamor" wrote: I have a column that has X if attended class then I need a sum of the number of students that attended on that column. What is the easiest way to do this without having to use the number 1 for attendance? so, issue is sum any X in a column and total at the bottom. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Help with Conditional Formula | Excel Worksheet Functions | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
Need Conditional Formula | Excel Worksheet Functions |