Win Rate tells you the percentage of matches a team won between 2020 and 2024. It is your baseline metric.

Now let's calculate total matches and wins to compute the win rate.

Introducing COUNTIF

COUNTIF counts rows matching a single condition.

=COUNTIF(range, condition)

Worked example — club match data

=COUNTIF(B:B, "PSG") would display the number 3 — it found PSG as the home team in M1, M3, and M6.

=COUNTIF(C:C, "PSG") would display the number 1 — it found PSG as the away team in M4 only.

So the formula to calculate the total number of matches played by PSG is: =COUNTIF(B:B, "PSG") + COUNTIF(C:C, "PSG") = 3 + 1 = 4

Column B: Total Matches

In your My Analysis tab, click on cell B4 (Spain's row).

Think about what you need to count: every match where Spain appears in the dataset — either as the home team or the away team.

Here's how to approach it:

• Count the number of matches where Spain is listed as the home team — use a COUNTIF on the home_team column
• Count the number of matches where Spain is listed as the away team — use a COUNTIF on the away_team column
• Add both results together with a + to get the total

A few things to keep in mind:

• Don't type "Spain" — use A4 so the formula updates automatically when you drag it down to other countries
• The Match Data tab reference looks like: '📊 Match Data'!B:B

Write your formula in B4 and drag it down to B33.

Introducing COUNTIFS

COUNTIFS counts rows matching multiple conditions at once.

=COUNTIFS(range1, condition1, range2, condition2, ...)

Reminder — club match data

Arsenal wins as away team (away_team = Arsenal AND result = away_win):

=COUNTIFS(C:C, "Arsenal", F:F, "away_win")   → 2   (M4 and M5)

Column C: Wins

A win for Spain can happen two ways:

• Spain is the home team (column B = A4) AND the result column says home_win
• Spain is the away team (column C = A4) AND the result column says away_win

Write two COUNTIFS in C4 — one for each situation — and add them together. The result column is column H of Match Data. Drag down to C33.

Start your formula with = and use + between the two COUNTIFS — just like a math calculation: = COUNTIFS(...) + COUNTIFS(...)

For Spain (row 4), the answer should be 15.

Column D: Draws

A draw happens when both teams scored the same number of goals — so the result column says draw regardless of whether the team was home or away.

Use the same two-COUNTIFS structure as column C. The only change: replace home_win and away_win with "draw" in both formulas. Write in D4 and drag down.

Find the highest Win Rate with MAX

Before answering, use the MAX formula to find it directly. Click on an empty cell (e.g. P3) in your My Analysis tab and type =MAX(F4:F33). This returns the highest Win Rate across all 30 countries instantly.