| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Countif non consecutive columns
I have the following:
Attended Attended A B C D E F 1 John Doe x Y x N ____ Column B and D with the x are if they are to attend and column C and E are whether they attended or not and it continues for several other courses. How do I sum or countif the nonconsecutive columns are Y? It will be column C, E, G, I etc but the same row. I need to tally how many they actually attended vs not attned in another column next to it. Thank you! Hope this makes sense! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Countif to Count Consecutive Relative Increases in Numbers | Excel Discussion (Misc queries) | |||
| Countif in non-consecutive cells | Excel Discussion (Misc queries) | |||
| Count non consecutive columns | Excel Worksheet Functions | |||
| how do i add consecutive columns in excel ? | Excel Discussion (Misc queries) | |||
| sumif/countif on non-consecutive colums - array? | Excel Worksheet Functions | |||
Threaded Mode
