How to count the number of people in each grade in excel?

The specific operations are as follows:

1. Open the excel form and enter the results of each subject into the excel form.

2. Enter and create a statistical table in the blank space of the table.

3. Double-click the double label in the cell where the statistical value needs to be entered to make it editable.

4. Then enter "=COUNTIFS(A3:A17,">=60",A3:A17,"<=79")" in the cell, where A3:A17 represents the statistical cell area, 60 and 79 are the numerical range.

5. After the input is completed, click the mouse elsewhere, and you can see the statistical results as shown in the figure.