How to remove the lowest and highest scores in excel to find the total score?
As shown in the figure below, there are scores in column B. Remove the highest score and the lowest score and find the total score of the remaining scores.
Recommended: "Excel Tutorial"
The sum function in Excel can be used to sum. Here we use sum to sum. First Enter the = sign to guide the formula, and then enter the sum function, as shown in the figure below.
Use the Large function to find the largest number in a data sequence. Here, first enter the large function as the parameter of the sum function, as shown in the figure below.
There are 10 numbers here, so only the 2nd to 9th largest numbers are required, and the lowest and highest scores are eliminated, so Row(2 :9), that is, the number sequence 2-9 is used as the second parameter of the large function, as shown in the figure below.
The final complete formula is: =SUM(LARGE(B2:B11,ROW(2:9))), but this is an array formula, so you need to press it at the same time Ctrl Shift Enter ends the formula and gets the final total score excluding the lowest and highest scores, as shown in the figure below.
The above is the detailed content of How to remove the lowest and highest scores in excel and find the total score. For more information, please follow other related articles on the PHP Chinese website!