How the WPS table implements multiple conditional sums

PS table to achieve multiple conditional sum method:

First of all, to open the grade test data, first of all, the statistical language score is greater than 100 points in each class number of students.

Select a range of cells (a1:j650), perform data → sort, and then select the primary keyword as "language" and "descending" sort.

Enter the formula in cell M2 "=countif (A$2:A$180,L2)" Statistics the number of students in Class 1, in which the cell area (a2:a180) is ranked after the student score is greater than 100 points of students.

Select the M2 cell, and then automatically fill it down to get the number of students in the other classes.