Formula Errors

How to Calculate Goalie Save Percentage by Team in Excel

Algirdas Jasaitis Sep 25, 2026 869 views

Question details

The user needs to calculate a goalie's save percentage for specific teams and all teams combined, ensuring the result cell remains blank if no team name is entered.

How to Calculate Goalie Save Percentage by Team in Excel

Product: Excel
Device & OS: not provided
Scenario: Tracking sports statistics to calculate a goalie's save percentage for specific teams using a dynamic formula.
Observed behavior: Requires a formula combining IF and SUMIFS to conditionally calculate saves divided by shots faced, while handling empty rows gracefully.

Before you start

Ensure your dataset is organized with clear columns for the team name, total saves made, and total shots faced before applying the formula.

Solution 1Recommended

Use the IF and SUMIFS Functions

Combine the IF function to handle blank team entries and SUMIFS to calculate total saves divided by total shots for a specific team.

This method uses conditional logic to check if a team name exists in a row. If it does, it calculates the save percentage by summing the relevant saves and dividing them by the relevant shots for that specific team.

Set up your data columns

Ensure your spreadsheet has designated columns. For example, use Column D for Team Name, Column F for Saves, and Column G for Shots.

Enter the combined formula

Select the target cell and enter the formula: =IF($D19="Kings",SUMIFS($F$3:$F19,$D$3:$D19,"Kings")/SUMIFS($G$3:$G19,$D$3:$D19,"Kings"),""). This checks if D19 is 'Kings', calculates the percentage, or returns a blank if false.

Apply formula to other rows

Click and drag the fill handle at the bottom-right corner of the cell to copy the formula down and across your dataset.

Absolute and Relative References: Pay attention to the absolute ($F$3) and relative ($F19) references. They are crucial for allowing the formula to expand its calculation range correctly as you drag it down.

Solution 2

Use SUMIF for Older Excel Versions

For older versions of Excel that do not support the SUMIFS function, you can use SUMIF with a single criteria.

Manage Sports Stats Easily

Calculate Save Percentages Effortlessly with WPS Spreadsheet

WPS Office Spreadsheet fully supports advanced mathematical and logical functions like IF, SUMIFS, and SUMIF. It makes tracking complex sports statistics like goalie save percentages straightforward and hassle-free.

1. Open your workbook: Launch WPS Spreadsheet and open your sports statistics document.
2. Select the target cell: Click on the cell where you want the calculated save percentage to appear.
3. Input the formula: Type the exact =IF and =SUMIFS formula just as you would in Microsoft Excel, and press Enter.
4. Fill the column: Drag the fill handle down to automatically calculate the save percentages for the remaining rows.

Highly compatible with Microsoft Excel (.xlsx) formats and formulasCompletely free to use with a familiar, easy-to-navigate interfaceRobust support for array formulas, conditional formatting, and dynamic rangesLightweight application that runs smoothly on almost any device

Frequently Asked Questions

Why does my save percentage formula return a #DIV/0! error?

This error occurs if the total shots faced for the team evaluate to zero, causing Excel to divide by zero. You can wrap your formula in an IFERROR function, like =IFERROR(your_formula, ""), to hide this error and display a blank cell instead.

How do I calculate the save percentage for all teams combined?

To calculate the overall save percentage across all teams, you do not need the SUMIFS criteria. Simply divide the total sum of all saves by the total sum of all shots using =SUM(F3:F19)/SUM(G3:G19).

Can I use a cell reference for the team name instead of typing it out?

Yes, to make the formula more dynamic, replace the hardcoded text (e.g., "Kings") with a cell reference like $D19. This allows the formula to automatically calculate the percentage based on whatever team name is typed in that specific row.

Excel & Data Problems