Classified summary is an important function of Excel, which can quickly take a field as a classified item and calculate the values of other fields in the data list. Taking the total data in the statistics table by department as an example, this paper introduces the operation method of classifying and summarizing the data in the Excel table.
1. Start Excel, open the worksheet, select the cell area where the classification fields are summarized, click the Sort and Filter button in the edit group of the Start tab, and select the descending command in the open menu to sort, as shown in figure 1.
Figure 1 Sort data.
2. Select any cell in the worksheet, click the Category Summary button in the Hierarchical Display group of the Data tab to open the Category Summary dialog box, select the Application Department option in the Category Field drop-down list of the dialog box, select the Sum option in the Summary Method drop-down list, and check it in the Selected Summary Item list.
Figure 2 opens the category summary dialog box.
3. Click "OK" to close the "Classification Summary" dialog box, and Excel will classify by the field of "Application Department" and sum and summarize the value of "Purchase Amount", as shown in Figure 3.
Figure 3 classifies and summarizes the worksheets.