ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   automatic subtotal (https://www.excelbanter.com/excel-worksheet-functions/95007-automatic-subtotal.html)

Carl501

automatic subtotal
 
Have Excel 2003. Can not get the Automatic Subtotal in a list function to
work.
When I select a range of data (labels) within my table, the menu command
Data - - Subtotal is "greyed out". If I select data on the same worksheet,
but NOT in the table, I can use the menu command Data --Subtotal. I have
reviewed the help topics in Excel and followed each step, but to no avail.
My teacher has also tried to get the function to work. Any hints?

Marcelo

automatic subtotal
 
Hi Carl,

did you try to use a subtotal in a Pivot table?

regards from Brazil
Marcelo

"Carl501" escreveu:

Have Excel 2003. Can not get the Automatic Subtotal in a list function to
work.
When I select a range of data (labels) within my table, the menu command
Data - - Subtotal is "greyed out". If I select data on the same worksheet,
but NOT in the table, I can use the menu command Data --Subtotal. I have
reviewed the help topics in Excel and followed each step, but to no avail.
My teacher has also tried to get the function to work. Any hints?



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

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