Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Calculate The Total Score Like The Olympics?

Date:2021-8-11 Author:Sandra

The Tokyo 2020 Olympics just ended.  As an audience, I saw many wonderful performances.  My favorite Olympic events to watch are diving and gymnastics.  How about you? 

We all know that the athlete’s score is calculated on average after removing the highest and lowest scores from the judges. So, today we are going to learn how to do this in Excel?

Let’s take the picture below as an example. Column A contains the names of the contestants, and columns B through F are the scores of the five judges.  Column G is the final score for each contestant. 

How To Calculate The Total Score Like The Olympics?

There are two ways that can help us to count the final score.

Method 1:

Just type =(SUM(B2:F2)-MAX(B2:F2)-MIN(B2:F2))/3 in cell G2. Then fill it.

How To Calculate The Total Score Like The Olympics?

You can keep the total score to only two decimal places.

How To Calculate The Total Score Like The Olympics?

Method 2:

We can use the TRIMMEAN Function.

Just type =TRIMMEAN(B2:F2,1/5*2) in cell G2 and fill.

How To Calculate The Total Score Like The Olympics?

How to understand the [=TRIMMEAN(B2:F2,1/5*2)]?

5 is the number of judges;  2 is the number of extremals that need to be removed because we have to get rid of the highest and the lowest scores. 

How To Calculate The Total Score Like The Olympics?

At the end of this tutorial, I want to leave you with a question to think about.  Suppose there are 10 judges who score, subtract 2 highest scores and 2 lowest scores, calculate the final average score, how should the formula be written? 

Just comment below if you know the answer.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *