Excel table to find the top 85% of the total score used to compare the results of each class. - Training Enrollment Network

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

Related articles

There are 10 vertical ways of addition, subtraction, multiplication and division in the fourth grade of primary school.

Elementary school graduation mathematics examination paper and answer

Two-month entrance examination mathematics 130

20 15 Hongkou district mathematics module 2

What's your major in junior college primary education?

I got 82 points in Chinese, 95 points in English and 87 points in moral character. My math score is 9 points higher than the average score of four courses. How many points did I get in the math exam?

Mathematical parallelogram in the second day of junior high school

20 13 spring college entrance examination mathematics examination paper

Analysis and Summary of the Mid-term Examination Quality of Class Teachers in Grade Two.