The Sum function was selected for the calculation in this example.Next, in the Use Function box, select the summary function that you want to use when totaling the columns.Choose the Category field, in this example, to add subtotal there.In the "At each change in" box, select the first column.When the Subtotal dialog box opens, follow these steps, to apply the subtotals: Then, in the drop down list of options, click Subtotal.If the Subtotal command is not visible, click the drop down arrow for Outline.
Then, in the Outline group, click the Subtotal button.Next, on the Excel Ribbon, click the Data.First, select any cell in the list that you want to subtotal.Note: In this example, the Category column will be subtotalled first, because it is the primary interest. Finally, to apply the sort order, click the OK button.Īfter the data is sorted, follow the steps below, to apply the first subtotal.Then, select options from its drop down boxes - sort on Values, and order A to Z.Next, to sort by the Product column, click the Add Level button.Next, from the Order drop down, select one of the options - A to Z, Z to A or Custom List.We're sorting on the values in the Category column, so leave the default setting of Values. Next, from the Sort On drop down, select the option that you want.Note: If the dropdown is showing Column letters instead of headings, add a check mark to My data has headers.In this example, Category will be the first column sorted. From the Sort by drop down, select the first column you want to sort.Click the Add Level button, to add the first sorting level.When the Sort dialog box opens, follow these steps for sorting data in the list: In the Sort & Filter group, click the Sort button, to open the Sort dialog box.On the Excel Ribbon, click the Data tab.Note: This is not required, but is recommended, to ensure that all of the data is sorted correctly.To sort the data by two columns, follow these steps: Will be subtotalled, so the data is sorted by those two columns. Video Timelineīefore applying subtotals, the data must be sorted by the column, or multiple columns, on
In this short video, you'll see the steps for creating subtotalswith the Subtotal command, and how to prevent the problem of duplicateĪre below the video, and the full video transcript is at the end of this page.