From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Find the top three

Find the top three - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Find the top three

“

- [Instructor] Here is a competition between the rockets and the choppers. There were 10 rounds. Everybody had to do something four times, and you got the scores. You see Mouse scored zero, 15, 12, and six. Now we have to figure out which are the top three from each team who will be going on to a next round. We calculate a score based on everybody's top three points. For Mouse, we're going to include 15, 12, and six. And let's look at this. I'm highlighting them. The sum is 33. For Elroy, he would have the 12, hold down a Control key, a two and a two. Down in the lower right we see Elroy's sum would be 16. Get those totals for all of the players. Find the top three on each team and come on back. All right? Pause the video. (upbeat music) Hopefully you chewed this up like great bubblegum. Let's do it. Here we go. Equals sum of the entire four minus min open parentheses and close parentheses, Enter. There's…

Contents