ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Moving Subtotals (https://www.excelbanter.com/excel-worksheet-functions/157132-moving-subtotals.html)

PHisaw

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





All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com