=SUM(cell references)
Total points per team for all rounds
Select the cell in which you want your result to appear
Type:
=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)
Press Enter
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.
Kommentarer