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: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. Sort by Customer
  2. On the DATA tab, in the Outline group, click the Subtotal command: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.Subtotal Dialog Box
Next