| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combination of Grouping and Subtotal
I've created a worksheet with several numbers grouped under a top level item.
I would like the top level item to display zero when the cells are expanded and then to roll up or subtotal the numbers below it when condensed. The subtotal 109 function behaves exactly opposite of what I'm trying to do. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUBTOTAL and COUNTIF (or SUMIF) combination | Excel Worksheet Functions | |||
| macro excel subtotal in subtotal | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
