summary function

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)