Calculate Subtotals and Totals : Subtotal « Formula « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Formula
  3. Subtotal
Click anywhere within the data to be subtotaled. 
           Click the Data tab. Click the Subtotals button.
Click anywhere within the data to be subtotaled. Click the Data tab. Click the Subtotals button.
Select the appropriate check boxes to specify how the data is subtotaled. Click OK.
Select the appropriate check boxes to specify how the data is subtotaled. Click OK.
Check the result.
Select the appropriate check boxes to specify how the data is subtotaled. Click OK.
6.13.Subtotal
6.13.1.Calculate Subtotals and TotalsCalculate Subtotals and Totals