top of page
Writer's pictureCaitlin Baird

example formulas & file for a sports scores worksheet

=SUM(cell references)

Total points per team for all rounds

  1. Select the cell in which you want your result to appear

  2. Type:

    1. =SUM(cell containing points for the first team in the first round, cell containing points for the same team in the second round, cell containing points for the same team in the third round)

  3. Press Enter

  4. Use AutoFill (hover over the fill handle - small green square in the corner of the highlighted cell - until your cursor turns into a black cross then click and drag down the column) to copy the formula for the rest of the teams

Total points per round for all teams

=SUM(cell containing the score for the first team in the first round:cell containing the score for the last score in the first round)

Depending on how you have laid out your data, you may be able to copy the formula or you may need to manually select the cells for each round

Total points scored overall

=SUM(cell containing results from 'Total points per round' for the first round:cell containing results from same for the last round)

Note: this assumes the results for all rounds are together in a range (a rectangular group of adjacent cells).

If they are not, simply select each result manually as in

=SUM(cell containing first result, second result, third...)

If you did not include 'Total points per round,' then

=SUM(cell with first result for first round:cell with last result for first round, same range for second round, third...)


=AVERAGE(cell references)

Average points scored per team for all rounds

=AVERAGE(cell containing the score for the first team in the first round:cell containing the score for the last score in the first round)

Repeat for each round

Average points scored per round for all teams

=AVERAGE(cell containing points for the first team in the first round, cell containing points for the same team in the second round, cell containing points for the same team in the third round)

Copy for each team

Average points scored per game overall

Same as for 'Total points scored overall' but using =AVERAGE


=MAX(cell references)

Highest points scored per round

=MAX(cell containing points for first team in the first round:cell containing points for last team in the first round)

Repeat per round

Best round per team

=MAX(cell containing points for the first team in the first round, cell containing points for the same team in the second round, cell containing points for the same team in the third round)

Copy for each team

Highest points scored in one game overall

Same as for 'Total points scored overall' but using =MAX


=MIN(cell references)

Lowest points scored per round

=MIN(cell containing points for first team in the first round:cell containing points for last team in the first round)

Repeat per round

Lowest scoring round per team

=MIN(cell containing points for the first team in the first round, cell containing points for the same team in the second round, cell containing points for the same team in the third round)

Copy for each team

Fewest points scored in one game overall

Same as for 'Total points scored overall' but using =MIN


Difference in points scored per team per game

=(cell with winning score for game one - cell with losing score for game one)

Copy for each game

Largest points discrepancy between teams in one game overall

=MAX(cell with results from previous for game one:cell with results from previous for final game)


There are many more, but they depend on how you've structured your data. I have created a small example which you can download below. My demo file includes IF, COUNT, and COUNTIF as well as many of the suggestions above. Note I have used structured (table) referencing in combination with cell referencing. To use structured references, format your data as a table.





Related Posts

See All

access to Pearson ebooks

Click here and choose the book for your course (MSE, MSP, MSW, BCA). If you want to download and save the ebook, you must first install...

welcome to Excel

Have you used the Pearson platform before? yes: access the platform and move on to step 2 no: begin with the Pearson success resources...

Comentários


bottom of page