Excel can automatically calculate subtotal and grand total values in a list. When
you insert subtotals, Excel outlines the list so that you can display and hide
the detail rows for each subtotal.
To insert subtotals, you first sort your list so that the rows you want to
subtotal are grouped together. You can then calculate subtotals for any column
that contains numbers.
- Open the spreadsheet that contains the data you wish to sort.
- Click once within the data.
- Perform your desired sort.
- Click on the word Data in the Menu bar.
- Select the option Subtotals.
- The Subtotal dialog will appear.
- Choose the desired column name from the At Each Change
In dropdown list.
- Choose the desired function from the Use Functions dropdown
list.
- Check the desired column on which to perform the function in the Add
Subtotal To list.
- Click on the OK button.
- Your data will be subtotaled and outlined.
- Click on the subtotaled numbers under the Name Box (1,
2 or 3 in the above example) to view the various
subtotals.
Note: To remove subtotals from your worksheet click once in your
data list, display the Subtotal dialog, and click on the
Remove All button.
Note 2: Do not use blank rows or dashed lines to separate
your column labels from the data list below, as blank rows and/or dashed lines
will be sorted.
Note 3: When you use formulas in your data, Excel sorts according
to the values displayed.
Click HERE to return to the Table of Contents.