=SUMIF(C3:C26, "> =" & large (C3: C26, INT (count (C3:C26)*0.85))/INT (count (C3:C26)* 0.85).
You can get the average score of the first 85% of Chinese, drag and copy it to D27, and get the average score of mathematics.
So are other classes!
Good luck with your work! ! !