Home  >  Article  >  Topics  >  How to remove the lowest and highest scores in excel and find the total score

How to remove the lowest and highest scores in excel and find the total score

藏色散人
藏色散人Original
2020-05-24 09:54:2113640browse

How to remove the lowest and highest scores in excel and find the total score

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"

How to remove the lowest and highest scores in excel and find the total score

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.

How to remove the lowest and highest scores in excel and find the total score

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.

How to remove the lowest and highest scores in excel and find the total score

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.

How to remove the lowest and highest scores in excel and find the total score

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.

How to remove the lowest and highest scores in excel and find the total score

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn