Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtotals
Operation No Part Number Sequence Number Material Cost
1 1 1 1 1 2 1 1 1 Total 2 2 2 2 8 2 Total 8 Grand Total 10 Was just wondering if there was a way of coding the subtotal so that after each subtotal it will calculate that total plus the previous totals. E.G. After "Operation No 2 Total", I want another line inserted that will give the sum total of "1 Total" and "2 Total". The amount of the inputted information will not stay the same and there will be more than two subtotals |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtotals
No, that is not an option under the subtotal command. (cumulative subtotals)
However, it isn't totally clear that you are describing cumulative subtotals. You might want to have groups and subgoups. To do that you can run a second subtotal command and remove the replace existing subtotals option when you run it a second time. Then subtotal on a different field. This is possibly what you are describing. -- Regards, Tom Ogilvy "enyaw" wrote: Operation No Part Number Sequence Number Material Cost 1 1 1 1 1 2 1 1 1 Total 2 2 2 2 8 2 Total 8 Grand Total 10 Was just wondering if there was a way of coding the subtotal so that after each subtotal it will calculate that total plus the previous totals. E.G. After "Operation No 2 Total", I want another line inserted that will give the sum total of "1 Total" and "2 Total". The amount of the inputted information will not stay the same and there will be more than two subtotals |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtotals
Hi
There is such a function if you use pivot table. Regards JY "enyaw" wrote in message ... Operation No Part Number Sequence Number Material Cost 1 1 1 1 1 2 1 1 1 Total 2 2 2 2 8 2 Total 8 Grand Total 10 Was just wondering if there was a way of coding the subtotal so that after each subtotal it will calculate that total plus the previous totals. E.G. After "Operation No 2 Total", I want another line inserted that will give the sum total of "1 Total" and "2 Total". The amount of the inputted information will not stay the same and there will be more than two subtotals |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals: Nested subtotals below higher subtotal | 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) |