Home > Sample chapters > Microsoft Office > Excel

Analyzing Your Excel 2013 Data

Subtotaling data values

Subtotaling cell values is another common calculation task that Excel can perform for you. You can find the Subtotal tool on the Data tab, in the Outline group.

Subtotal data values

  1. Select the data, including column headers, for which you want a subtotal.

  2. Click the Data tab.

  3. Click Subtotal.

  4. Select when you want the function to be applied.

  5. Choose the subtotal function that you want to use.

  6. Select what you want to subtotal.

  7. Choose the check box to specify where you want the subtotal to appear.

  8. Click OK.