Guided project · 6 steps Cellwise Plus
Soccer season report in Excel
Turn a youth soccer season into goal contributions, a scoring rate per full game and an awards list.
You will use: ROUND, SUM, COUNTIF, MAX, MATCH, INDEX
Starting data
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Player | Games | Minutes | Goals | Assists | Goals + assists | Per 60 minutes | Team goals | |
| 2 | Lena | 12 | 610 | 9 | 4 | Players with a goal | |||
| 3 | Omar | 12 | 580 | 6 | 6 | Top contributor | |||
| 4 | Grace | 11 | 540 | 4 | 2 | Top scorer's share | |||
| 5 | Mateo | 10 | 390 | 5 | 1 | ||||
| 6 | Ivy | 12 | 470 | 0 | 5 | ||||
| 7 | Ben | 9 | 300 | 2 | 3 | ||||
| 8 | Nina | 12 | 520 | 1 | 0 | ||||
| 9 | Ravi | 8 | 210 | 3 | 0 |
Build it step by step
Step 1
A goal contribution is a goal or an assist. Add them for Lena in F2 and fill down to F9.
Step 2
Players get different minutes, so compare scoring rates. In G2 work out goals + assists per 60 minutes (a full youth game), rounded to 2 decimals. Fill down.
Step 3
Total the team's goals in J1.
Step 4
How many players have scored at least one goal? Put it in J2.
Step 5
Who has the most goal contributions? Return the name in J3.
Step 6
What share of the team's goals did the top scorer get? Divide the most goals by J1 and round to 2 decimals in J4.