| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formula or not?
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
|
|||
|
|||
|
Conditional formula or not?
=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
|
|||
|
|||
|
Conditional formula or not?
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
