ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Subtotals Nesting Error - Totals Above (https://www.excelbanter.com/excel-worksheet-functions/158013-subtotals-nesting-error-totals-above.html)

bart972

Subtotals Nesting Error - Totals Above
 
For Excel 2003, when I do automatic subtotals and select Totals ABOVE the
data, I get a nesting error when I do subtotals for the 2nd level and higher.
Excel takes the top line of data and mis-interprets it, messing up the rows
to be totaled. Even the grand total is wrong. Totals BELOW the data is OK.
--
bart972


All times are GMT +1. The time now is 01:01 PM.

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