Adding Subtotals
The Subtotals feature automatically creates groups and subtotals the related data according to your specifications. You can subtotal data according to any of your column headers on a sheet of data.
Use the following procedure to add subtotals.
- Make sure that each column of data has a label in the first row. It must also contain similar facts. Don’t include any blank rows or columns.
- Select the Data tab from the Ribbon.
Select Subtotal.
In the Subtotal dialog box, select the locations for the subtotals from the At each change in drop down list.
Select the function to use in the subtotal fields from the Use Function drop down list.
- Check the boxes that correspond to your column headers for which column(s) to subtotal.
- Check the boxes to indicate the other formatting options by checking or clearing the Replace current subtotals, Page break between groups, and Summary below data.
- Select OK.