| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum sub levels.
Hi Jerome,
You would need to write a macro. Do you only have Level 1 and Level 2 You would have to generate formulas where you have 1 in column A with a macro if that is the case. The numbers are just random constants for test. =SUBTOTAL9,D2:D14) =SUBTOTAL(9,D3:D5) 8 37 52 =SUBTOTAL(9,D7:D7) 46 =SUBTOTAL(9,D9:D14) 76 11 81 69 61 83 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum sub levels. | Excel Discussion (Misc queries) | |||
| sum sub levels. | New Users to Excel | |||
| How to setup a nested if function with 10 levels? | Excel Worksheet Functions | |||
| IF function with 14 nested levels | Excel Worksheet Functions | |||
| Levels in Subtotals | Excel Worksheet Functions | |||
Threaded Mode
