1. Set up your data and summary table
In Google Sheets, create a table with columns: Game, Team, and Result. Below that, build a Summary Table with Team, Wins, Losses, and Win-Loss Ratio.
2. Fill in match results for each team
Use consistent labels like Team A, Team B, and results as Win or Loss. Keep naming consistent for formulas to work correctly.
3. Count wins and losses using COUNTIFS
In the Wins column (e.g. B14), use: =COUNTIFS(B$2:B$11, A14, C$2:C$11, "Win"). In the Losses column (e.g. C14), use: =COUNTIFS(B$2:B$11, A14, C$2:C$11, "Loss"). Make sure these reference only the original data range, not the summary table.
4. Avoid circular dependency errors
When calculating the win-loss ratio in D14, don’t reference D14 in its own formula. Instead, use: =IF(C14=0, "N/A", B14 / C14). This prevents divide-by-zero errors and avoids circular references.
5. Format numbers properly
If your win/loss totals or ratio show as dates, select the cells, go to Format > Number > Number. Use the toolbar to increase or decrease decimal places as needed.
