basic excel training - List Management

Hi Beckie

Thanks for your question.

First you need to make sure your list is sorted in an order so that when the subtotals are inserted, they are put in a position that makes sense, e.g. if I have a list of products and want to calculate total sales for each product, then I need to sort by product first.

Then to apply subtotals:
1. Select a cell within the list area.
2. Go to Data - Subtotals.
3. Select the function you wish to use, then tick the column/s you want to put the subtotals into, then click OK.

I hope this answers your question. Please let me know if you need further assistance with this.

Amanda

Beckie

Preparing your Data
Before you can add subtotals to your data you must check that all the rows you want to subtotal are next to each other. The quickest way to do this is probably by sorting the data.

If you filter on a particular value, Excel will automatically generate a row of SUBTOTALs at the bottom of the filtered results. The first parameter in the SUBTOTAL(FncNum, Range) is the summary function used in the subtotal.
Data | Subtotals lets you do Outlining specifying the data breaks and what kind of subtotals you want at those breaks. The Outlining plus and minuses at the left let you control the level of detail that is displayed.

hope this answers your question


regards

david