Adding Subtotals to a List - Exercise

Contact Us or call 1-877-932-8228
Adding Subtotals to a List - Exercise

Adding Subtotals to a List

Duration: 10 to 20 minutes.

In this exercise, you will practice adding subtotals to a list in Microsoft Excel.

  1. Open Subtotals.xlsx from your Excel2013.2/Exercises folder.
  2. Add subtotals showing total sales by customer.

Solution:

  1. In order to add subtotals showing total sales by customer, it is necessary to first sort by customer. To sort by customer:
    1. Select any cell within the list.
    2. On the DATA tab, in the Sort & Filter group, click the Sort command:
    3. In the Sort dialog box:
      1. Verify that My data has headers is checked.
      2. Choose to sort by Customer.
      3. Click OK.
  2. On the DATA tab, in the Outline group, click the Subtotal command:
  3. In the Subtotal dialog box:
    1. In the At each change in box, select Customer.
    2. In the Use function box, choose Sum.
    3. In the Add subtotal to box, check Sale.
    4. Click OK.
Next