Inside Microsoft Excel


Break down lengthy lists with multilevel subtotals

Inside Microsoft Excel

by T. L. Thomas

Once you’ve discovered the incredible amount of time and effort the Subtotals feature can spare you, you’re bound to use it whenever you can. Inevitably, you’ll reach the point when you begin to wonder how to push this feature’s limitations by subtotaling subsets of data in a list that you’ve subtotaled once already. Take, for instance, the sales tracking worksheet shown inĀ Figure A. We’ve already used the Subtotals feature to subtotal[…]

 

Subscribe to Inside Microsoft Excel

(get full access to archives and more)