How to classify and summarize in excel

Method for classification and summary: 1. Select the column that needs to be classified and summarize, and click "Data" - "Sort Ascending" in the menu bar; 2. In the "Data" tab, click "Classification and Summary"; 3. In the "Classification Summary" dialog box, set the "Category Field" to the column name of the classification summary, check the required items in "Selected Summary Items", and click "OK".

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Excel classification and summary method:

1. Select the column that needs to be classified and summarized: select "Data" in the menu and click Sort in ascending order.

#2. Subdivision and summary: On the "Data" tab, click "Subdivision and summary".

Third, select the corresponding item in the classification and summary dialog box: select the column name to be classified and summarized in the classification field, here select "Class"; select the summary item and check " "Word, Number, English" three columns, click "OK". as the picture shows.

#Follow the above steps to get the interface diagram after classification and summary, as shown in the figure below. Click 1, 2, and 3 on the left to display the summarized items respectively.

View example: Select 2, the display is as follows, indicating: the summary scores of all classes classified by language, mathematics, and English.

The above is the detailed content of How to classify and summarize in excel. For more information, please follow other related articles on the PHP Chinese website!