ExcelBanter

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

Davine

Subtotals
 
When I subtotal at 3rd level the subtotal is not going to the bottom of the
data, although the tick box is clicked. I have data by company, branch, and
customer. I sorted in that order. I subtotaled by company and all is well.
I subtotaled by branch - again, all is well. I subtotaled by customer and my
customer subtotals end up above and below the branch subtotal.

Dave Peterson

Subtotals
 
Maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824

Davine wrote:

When I subtotal at 3rd level the subtotal is not going to the bottom of the
data, although the tick box is clicked. I have data by company, branch, and
customer. I sorted in that order. I subtotaled by company and all is well.
I subtotaled by branch - again, all is well. I subtotaled by customer and my
customer subtotals end up above and below the branch subtotal.


--

Dave Peterson


All times are GMT +1. The time now is 02:07 AM.

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