grand total

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)