The steps for WPS table statistics operation are as follows:
① Select cell M2, click the "Insert Function" button, and select "Multiple Condition Sum" in the list of common formulas. The area to be summed in the parameters is the class, condition 1 is that the class is equal to 1, and condition 2 is that the language is not less than 100 points and click Insert Formula.
Since the result obtained is the "sum" that satisfies the condition, and what is expected here is the number of items that satisfies the condition, the formula "SUMPRODUCT($A$2:$A$650,1*(OFFSET($A$2:$A$650 ,0,SUM(COLUMN($A$2 :$A$650)-COLUMN($A$2:$A$650)))=1)*(OFFSET($A$2:$A$650,0,SUM(COLUMN($B$2:$B$650)-COLUMN( $A$2:$A$650)))>=100))”
Change it to "=(SUMPRODUCT($A$2:$A$650,1*(OFFSET($A$2:$A$650,0,SUM(COLUMN($A$2:$A$650))-COLUMN($A$2:$ A$650)))=$L2)*(OFFSET($ A$2:$A$650,0,SUM(COLUMN(B$2:B$650)-COLUMN($A$2:$A$650)))>=100)))/$L2”, that is, the individual that meets the conditions is obtained Number (the number of people in class 1 whose Chinese score is greater than or equal to 100 points, pay attention to the usage of relative reference and absolute reference in the formula).
② Select the M2 cell, automatically fill it to the right to the P2 cell, then modify the parameters of the formula in each cell (that is, the fraction segment to be counted, such as physics >= 80), and then select the (M2: P2) cell Area, automatically fill down, you can quickly count the number of students in each class of Chinese, mathematics, English, and physics.
The above is what the editor said aboutThe WPS table uses the multi-condition summation function to count test scores. I hope it will be helpful to everyone. For more exciting tutorials, please pay attention to Huajun Software Park.
