subtotals

There can sometimes be situations when it is necessary to add more than one summary function to a list. For example, you may want to present both subtotals and averages for the groups within a data list. To display summary functions follow these ... steps: Sort the data list on the field or fields by which the data should be grouped. Position the active cell within the data list. Choose Data | Subtotals. The Subtotal dialog box will appear. Specify options for the first subtotal. Choose OK. Choose Data | Subtotals. The Subtotal dialog box will appear again. Specify options for the second subtotal ... (view more)

When automatic subtotals are inserted, Excel outlines the list by grouping detail rows with each associate subtotal row, and grouping subtotal rows with the grand total row. To insert subtotals and grand totals in a data list, follow the ... instructions below: Sort the data list on the field or fields by which the data should be grouped. Position the active cell within the data list. Select Data | Subtotals. The Subtotal dialog box appears. Select a field by which to group from the At each change in drop-down list. Select a calculation function from the Use function drop-down list. Select the ... (view more)

When AutoFilter is activated, Excel recognizes that a calculated total should reflect only the record that are currently displayed in the data list. For example, in a data list of business expenses with an Amount field, it would be possible to ... create a formula at the bottom of the field that reflects the total amount of only those amounts displayed by the filter. The SUBTOTAL function is used to calculate a total amount based on a filter. Follow these steps to use the SUBTOTAL function with AutoFilter: Click in a cell in the column to subtotal. Click Sort Ascending or Sort Descending. On the ... (view more)