Excel data classification summary statistics of the number of students in each class

1. We need to sort the data before classification and summary. Of course, it is an important class because we need to classify and summarize the class.

2. After sorting, click "data" & rarr; "category summary" on the menu bar, as shown in the following figure.

3. In the summary, click "class", and select "count" as the summary item and "name" as the summary item. Of course, the other items in this table are the same.

4. The point is shown in the figure.

5. We will find the number of students in each class come out.

6. If a mistake occurs, you can simply click "data" menu & rarr; "category summary" and then click "delete all". This will not affect the actual data.