ExcelBanter - Subtotals in lists

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Subtotals in lists (https://www.excelbanter.com/excel-discussion-misc-queries/130253-subtotals-lists.html)

Kaokulk

Subtotals in lists

In Excel 2003, if I create a list, the Subtotal option grays out. How can I
get a report with subtotals if I've defined lists?

Dave Peterson

Subtotals in lists

Convert the list back to a range?

Depending on what you're doing, maybe you could use a pivottable???

Kaokulk wrote:

In Excel 2003, if I create a list, the Subtotal option grays out. How can I
get a report with subtotals if I've defined lists?

--

Dave Peterson

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