Current location - Training Enrollment Network - Mathematics courses - Excel table to find the top 85% of the total score used to compare the results of each class.
Excel table to find the top 85% of the total score used to compare the results of each class.
The data of Class One is in C3:C26, and we write the formula in C27:

=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! ! !