Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotaling
I need a formula to subtotal each set of 1's in a column, without subtotaling
other numbers in the column. example shown below. 1 ) 1 ) subtotal = 2 2 ] 5 ] 6 ] 7 ] no subtotal 1 ) 1 ) 1 ) 1 ) 1 ) 1 ) subtotal = 6 5 ] 6 ] 7 ] 6 ] 5 ] no subtotal 1 ) subtotal = 1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotaling | Excel Worksheet Functions | |||
Subtotaling | Excel Worksheet Functions | |||
Display when subtotaling. | Excel Discussion (Misc queries) | |||
subtotaling | Excel Discussion (Misc queries) | |||
subtotaling every third row? | Excel Worksheet Functions |