Excel Formulas

Basketball Team: Player Statistics

Back to Tutorial
#### Lesson 13: Basketball Team: Player Statistics

#### "Hey! There you are! So, I've been keeping track of my daughter's basketball team with a spreadsheet…

#### Our spreadsheet

#### What are we trying to figure out?

#### Writing the formula

#### Writing the formula

#### "Wow! Thank you!

#### Highest-scoring game for each player

#### Highest-scoring game

#### "Say, this is just great!

/en/excelformulas/percentoff-sale/content/

…and I want to help the coach calculate some different stats. I've recorded how many points each player scored during each game. Could you help me figure out **who's scored the most points overall?**"

Once you've downloaded our spreadsheet, open the file in Excel or another spreadsheet application. You may want to take a moment to see how the data is organized. As you can see, there is a different row for each of the players and different columns for the number of points they scored in each game.

Before we write our formulas, let's think about the problem we're trying to solve. Our friend wants to find out **which player scored the most points total over these five games**.

Now that we know what function to use, we'll start by calculating the total points scored for Tonya in row 2.

Before we write the formula, we'll need to decide what cell range to include in the argument.

Now we're ready to write our formula. Go to the next page to see our formula in action!

Now that we know what **function** and **cell range** to use, we're ready to enter our formula, **=SUM(B2:F2)**, in cell G2:

It looks like Tonya scored 51 points total. Next, we'll drag the fill handle down to add this formula for the other players.

There we go! It looks like Bella scored the most points overall. However, we could take it a bit further to make our data really stand out. For example, we could:

- Apply
**conditional formatting**to highlight the highest values **Create a chart**to visually compare the results**Sort**the results

There's really no right answer in this case—the most important thing is to make your data clear and easier to understand. In this example, it might be especially helpful to** sort the data** by the total points scored from **highest to lowest**—this will show who the top scorer is and make it easier to rank the other players on the team. Sorting works a bit differently, depending on which spreadsheet program you're using:

- For
**Excel 2007-2019**: Select column G, then click the**Descending Sort (Z-A)**command on the**Data**tab. - For
**Excel 2003 and earlier**: Select column G, then click**Data > Sort > Descending**. - For
**Google Sheets**: Select column G, then click**Data > Sort sheet by column G > Descending**.

OK, now it's really easy to read our results! We can tell at a glance that Bella is the highest scorer, and we can also rank the other players.

You know, I'd love to calculate some other statistics so I can tell each of the players about something they've accomplished. Could you help me figure out **how many points each of the players scored in their best-scoring game**?"

Now we'll need to answer this question: How many points did each of the players score in their best-scoring game?

Now that we know what function to use, we'll start by finding the highest-scoring game for Bella in row 2.

Before we write our formula, we'll need to decide what cell range to include in the argument.

Go to the next page to see our formula in action!

Now that we know what function and cell range to use, we'll type our formula, **=MAX(B2:F2)**, in cell **H2** and then use the **fill handle** to add it to the other cells in column H.

Now we can easily see how many points each of the players scored in their highest-scoring game!

It's interesting to see that Hope had the highest-scoring game, even though she didn't score the most points overall. And every player scored at least 10 points in one of their games, which is something they can all be proud of! I can't wait to show this to the team. Thanks again!"

/en/excelformulas/movie-tickets-/content/