You can automatically calculate subtotals and grand totals in a list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.) for a column by using the Subtotal command in the Outline group on the Data tab.
If the workbook is set to automatically calculate formulas, the Subtotal command recalculates subtotal and grand total values automatically as you edit the detail data. The Subtotal command also outlines (outline: Worksheet data in which rows or columns of detail data are grouped so that you can create summary reports. The outline can summarize either an entire worksheet or a selected portion of it.) the list so that you can display and hide the detail rows for each subtotal.
Tip To display a summary of just the subtotals and grand totals, click the outline symbols next to the row numbers. Use the and symbols to display or hide the detail rows for individual subtotals.
1-Click a cell in the list that contains a subtotal.
2-On the Data tab, in the Outline group, click Subtotal.
3-The Subtotal dialog box is displayed.
4-Click Remove All