Win rate tells you how often a team wins. Over five years it is the most direct sign of consistency. You'll write two formulas (matches, then wins); the rate then calculates itself.
Which formula gives a team's win rate? (W = total number of wins, M = total number of matches played)
Read the chart: what is Japan's win rate?
Read the chart: which teams won more than 70% of their matches?
COUNTIF: count rows that match
COUNTIF(range, condition) counts the cells of a range equal to a value. Club example:
| A | B | C | D | E | F |
|---|---|---|---|---|---|
| Match | Home Team | Away Team | Home Score | Away Score | Result |
| M1 | PSG | Arsenal | 3 | 1 | home_win |
| M2 | Arsenal | Chelsea | 2 | 2 | draw |
| M3 | PSG | Barcelona | 1 | 2 | away_win |
| M4 | Arsenal | PSG | 0 | 1 | away_win |
| M5 | Chelsea | Arsenal | 1 | 3 | away_win |
| M6 | PSG | Chelsea | 4 | 0 | home_win |
=COUNTIF(B:B, "PSG") → 3
=COUNTIF(B:B, "PSG") + COUNTIF(C:C, "PSG") → 4 (3 home matches + 1 away match)
A team appears in the home column or the away column, so its total matches = two COUNTIFs added together.
COUNTIFS: several conditions at once
COUNTIFS(range1, cond1, range2, cond2) counts rows where all conditions are true. Same club table:
=COUNTIFS(C:C, "Arsenal", F:F, "away_win") → 1 (Arsenal won 1 match as the away team)
=COUNTIFS(B:B, "Arsenal", F:F, "home_win") + COUNTIFS(C:C, "Arsenal", F:F, "away_win") → 1 (0 home wins + 1 away win)
Look at the club table: how many matches did PSG win in this table?
Your turn: column B (total matches) = two COUNTIFs added together; column C (wins) = two COUNTIFS added together.
Once B and C are applied, column F (win rate = wins ÷ matches) fills itself in.
'📊 Match Data'!B:B. Easier: while you type your formula, click the tab, then click the column header. We write it for you.Type ( , ; or an operator, then click a column or a cell to insert it.
Editing 📝 My Analysis!B4
| A | B | C | F | |
|---|---|---|---|---|
| 1 | FIFA World Cup 2026 — My Analysis | |||
| 2 | ||||
| 3 | Team | Total Matches | Wins | Win Rate (% 5y) |
| 4 | Spain | |||
| 5 | Portugal | |||
| 6 | France | |||
| 7 | Germany | |||
| 8 | England | |||
| 9 | Netherlands | |||
| 10 | Norway | |||
| 11 | Austria | |||
| 12 | Belgium | |||
| 13 | Croatia | |||
| 14 | Switzerland | |||
| 15 | Scotland | |||
| 16 | Turkey | |||
| 17 | Argentina | |||
| 18 | Brazil | |||
| 19 | Colombia | |||
| 20 | Uruguay | |||
| 21 | Ecuador | |||
| 22 | Paraguay | |||
| 23 | USA | |||
| 24 | Mexico | |||
| 25 | Canada | |||
| 26 | Morocco | |||
| 27 | Senegal | |||
| 28 | Nigeria | |||
| 29 | Ghana | |||
| 30 | Japan | |||
| 31 | South Korea | |||
| 32 | Saudi Arabia | |||
| 33 | Australia |
Column B — Total Matches. In B4, count how many times Spain (A4) appears as home team plus as away team in 📊 Match Data.
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.