Momentum shows whether a team is playing better or worse than usual right now. Momentum = win rate (last 5 matches) − win rate (5 years), in percentage points (pp).
Read the chart: which teams are doing worse recently than over 5 years?
Read the chart: what is Germany's momentum?
Column J (Last 5 Wins) is pre-filled, and column K (= J ÷ 5) fills itself in to turn it into a win rate…
…your turn: compute the momentum in column L.
Type ( , ; or an operator, then click a column or a cell to insert it.
Editing 📝 My Analysis!L4
| A | F | J | K | L | |
|---|---|---|---|---|---|
| 1 | FIFA World Cup 2026 — My Analysis | ||||
| 2 | |||||
| 3 | Team | Win Rate (% 5y) | Last 5 Wins | Win Rate (% last 5) | Momentum (pp) |
| 4 | Spain | 5 | 100.0% | ||
| 5 | Portugal | 3 | 60.0% | ||
| 6 | France | 2 | 40.0% | ||
| 7 | Germany | 3 | 60.0% | ||
| 8 | England | 2 | 40.0% | ||
| 9 | Netherlands | 3 | 60.0% | ||
| 10 | Norway | 2 | 40.0% | ||
| 11 | Austria | 1 | 20.0% | ||
| 12 | Belgium | 1 | 20.0% | ||
| 13 | Croatia | 0 | 0.0% | ||
| 14 | Switzerland | 1 | 20.0% | ||
| 15 | Scotland | 2 | 40.0% | ||
| 16 | Turkey | 3 | 60.0% | ||
| 17 | Argentina | 5 | 100.0% | ||
| 18 | Brazil | 2 | 40.0% | ||
| 19 | Colombia | 2 | 40.0% | ||
| 20 | Uruguay | 2 | 40.0% | ||
| 21 | Ecuador | 3 | 60.0% | ||
| 22 | Paraguay | 2 | 40.0% | ||
| 23 | USA | 3 | 60.0% | ||
| 24 | Mexico | 1 | 20.0% | ||
| 25 | Canada | 1 | 20.0% | ||
| 26 | Morocco | 4 | 80.0% | ||
| 27 | Senegal | 4 | 80.0% | ||
| 28 | Nigeria | 2 | 40.0% | ||
| 29 | Ghana | 3 | 60.0% | ||
| 30 | Japan | 5 | 100.0% | ||
| 31 | South Korea | 2 | 40.0% | ||
| 32 | Saudi Arabia | 5 | 100.0% | ||
| 33 | Australia | 3 | 60.0% |
Columns B, C from an earlier page aren't done yet.
Column L — Momentum. In L4, subtract the 5-year win rate from the last-5 win rate.
Columns F and K must be filled in first — momentum compares them. Finish B and C on the Win Rate page (or use the button above).
Function names in your language
| EN | FR | ES | IT |
|---|---|---|---|
COUNTIF | NB.SI | CONTAR.SI | CONTA.SE |
COUNTIFS | NB.SI.ENS | CONTAR.SI.CONJUNTO | CONTA.PIÙ.SE |
VLOOKUP | RECHERCHEV | BUSCARV | CERCA.VERT |
Both work here, and you can separate arguments with , or ; — just like in a real spreadsheet.