Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving Subtotals
Is there a way to change where the subtotal is inserted when DataSubtotals
is selected for calculations? For example, I have a spreadsheet with the following columns and it places a subtotal under jobs when they are counted and under calcualted time when time is summed. I'd like for both to be under the calculated time, if possible. JobNumber Type Start Stop Calculated 9999 xxx 1:00 2:00 1:00 9998 xxx 2:00 3:00 1:00 JobNumberTotal 2 JobNumberTotal 2:00 Would like it to be: JobNumberTotal 2 JobNumberTotal 2:00 If anyone has any ideas to make this work without manually moving each cell, it would be greatly appreciated! Thanks, Pam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
keyboard shortcut 4 moving btwn subtotals groups. | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) |