Form: name, language and number. Take Chinese achievement as an example.

(1) Select all "Chinese scores" cells, such as B2:B50, and select "Menu-Insert-Name-Definition-Language"-Add, that is, define the area B2:B55 as "Language" (Chinese scores).

(2) statistics >; =90, please use the formula =COUNTIF (English, "> =90").

80 (inclusive) -90, =COUNTIF (English, "> =80")-COUNTIF (English," > =90 ")

70 (inclusive) -80, =COUNTIF (language, "> =70")-COUNTIF (English," > =80 ")

60 (inclusive) -70, =COUNTIF (English, "> =60")-COUNTIF (English," > =70 ")

& lt60, =COUNTIF (language, "

(3) Step 1 can be omitted and the word "language" in Step 2 can be changed to "B2:B50".

(4) Number, English and total score: The same is true.