To average percentages in Excel, enter the percentage values in a range and use =AVERAGE(C2:C6). This formula assumes the percentages are in C2:C6; for 80%, 90%, 75%, 100%, and 85%, it returns 86% when the result is formatted as a percentage. Before calculating, make sure the cells contain percentage values rather than whole-number labels such as 80 that Excel may interpret differently.
A simple average is useful when each percentage should count equally, such as averaging five quiz scores. If the percentages come from groups with different sizes, a weighted average may be more appropriate: combine the underlying counts instead of averaging the rates. The steps below show how to calculate both and how to check the result.
What You’ll Need
- An Excel workbook with the percentages or the original counts that produce them.
- A blank cell where you can enter the formula.
- A clear idea of whether each percentage counts equally or whether the groups have different sizes.
These instructions are for Microsoft Excel for Microsoft 365 on Windows. The formulas also work in current Excel for Mac and Excel for the web. Ribbon labels can look slightly different on Mac or in a browser.
Step-by-Step
-
Decide what kind of average you need. Use a simple average when every percentage is one equally important observation. For example, if you want the average of five students’ test scores, each student’s score usually counts once. Use a weighted average when each percentage is based on a different number of items, people, attempts, or transactions. If one class has 10 students and another has 100, averaging their pass rates equally will not give the overall pass rate for all 110 students.
-
Arrange and check the percentage values. Put one percentage in each cell in a single column or row, with no headings mixed into the data range. For example, enter 80%, 90%, 75%, 100%, and 85% in C2:C6. Typing the percent sign makes Excel store each entry as a percentage value: 80% is stored as 0.8. If your data is currently written as 80, 90, and 75 to mean percentages, convert those values to actual percentages before using them. Applying percent formatting to 80 displays 8000%, because the stored value is 80, not 0.8.
-
Choose a cell for the answer. Click an empty cell outside the data, such as C7, so the result does not overwrite a percentage or become part of its own input range. If you put the answer directly below the values, confirm that the formula refers only to C2:C6. Keeping the result separate from the source data makes later review and updates easier.
-
Enter the AVERAGE formula. With percentages in C2:C6, enter
=AVERAGE(C2:C6)in C7, then press Enter. Excel calculates the arithmetic mean by adding the numeric values and dividing by the number of numeric values. For the example values, the calculation is (80% + 90% + 75% + 100% + 85%) ÷ 5 = 86%. If your data occupies a different range, replace C2:C6 with that range, keeping the colon between the first and last cells. -
Format the answer as a percentage. Select the result cell. On Windows, go to Home > Number and select Percent Style. You can also use the Windows shortcut Ctrl+Shift+%. The formula returns a decimal value—0.86 for this example—and percentage formatting displays it as 86%. On Mac, use Home > Number Format > Percentage or the Percent Style button; if a shortcut differs with your keyboard or Excel settings, use the ribbon. In Excel for the web, select the cell and choose Home > Number Format > Percentage.
-
Set the number of decimal places if needed. Percentage formatting may initially show a whole number, such as 86%. To show greater precision, select the result and use Increase Decimal in the Home tab’s Number group. The example average is exactly 86%, so extra decimal places would show 86.00% without changing the underlying value. For data that does not average to a whole percentage, such as 80% and 81%, showing one or two decimal places can make the result more informative.
-
Calculate an overall rate when group sizes vary. If you have success counts and totals, calculate the combined rate from those counts rather than taking the ordinary average of the rates. Suppose successes are in B2:B4 and total attempts are in C2:C4: row 2 has 18 successes out of 20, row 3 has 45 out of 60, and row 4 has 32 out of 40. In a blank cell, enter
=SUM(B2:B4)/SUM(C2:C4). The combined result is 95 ÷ 120 = 79.1667%, displayed as 79.17% with two decimal places. The unweighted average of 90%, 75%, and 80% would instead be 81.67%, answering a different question because it gives each group equal weight. -
Check that the formula covers the intended data. Click the result cell and inspect the formula bar. Confirm that the first and last cells are correct, and that no heading, old result, or unrelated value is included. If you add more percentages later, expand the range or use an Excel Table so new rows can be included more reliably. Recheck the result after changing or sorting the source data.
Common Mistakes
-
Using whole numbers as though they were percentages. A cell containing 80 is eighty, not 80%. If it is formatted as a percentage, Excel displays 8000%. Convert the data to decimal percentage values—80% or 0.8—before calculating. Do not simply change the display format and assume the underlying values have changed.
-
Averaging rates from groups of unequal sizes. AVERAGE gives each numeric cell equal influence. It does not know that one rate came from 10 attempts and another from 1,000. Use the combined numerator divided by the combined denominator when the question is about the overall rate across all items.
-
Including the result cell in its own range. If the answer is in C7, a formula that includes C7, such as
=AVERAGE(C2:C7), creates a circular reference. Use the source cells only, such as C2:C6. -
Assuming blank cells and zeros mean the same thing. AVERAGE ignores blank cells and text, but includes numeric zeros. If a zero means a real 0% result, it should count. If it means missing data, do not enter it as zero unless you intend it to lower the average.
-
Rounding the input values too early. A displayed value of 82% may contain more decimal places than are visible. AVERAGE uses the stored values, not just the displayed digits. Keep the original precision and adjust the display decimals unless you have a specific reason to round the data itself.
Tips
-
Give the source column a clear heading, such as Quiz score, and label the answer Average score. This makes the result easier to interpret when someone else opens the workbook.
-
Use Excel’s formula suggestions: type
=AVERAGE(, select the cells, type the closing parenthesis if needed, and press Enter. Selecting a range with the mouse can reduce reference mistakes. -
For a range with a heading in the first row, select only the numeric percentage cells. AVERAGE ignores text in a referenced range, but excluding headings makes the formula clearer and avoids accidentally including unrelated numeric entries.
-
Keep the formula result as a number and use cell formatting to control how it appears. This lets you use the average in later formulas without converting it to text.
-
When percentages are in an Excel Table, consider using the table column in the formula so the calculation can expand as rows are added. Check the generated formula and result after adding data, especially if the table includes totals or summary rows.
Troubleshooting
The result looks 100 times too large. This usually means whole numbers such as 80 were formatted as percentages, or the result was multiplied by 100 and then percentage-formatted again. For ordinary percentage values, enter 80% or 0.8 and let the percentage format display the result. Do not multiply the AVERAGE result by 100 if you plan to apply Percent Style.
The formula shows an error or does not calculate. Check that the formula begins with an equals sign, the range uses a colon, and the parentheses are balanced. If Excel displays the formula as text, change the cell format from Text to General, then re-enter the formula. Also check whether Show Formulas is on; press Ctrl+` on Windows to toggle it, or use Formulas > Show Formulas. On Mac, the shortcut may depend on the keyboard layout, so use the Formulas tab command.
The answer is lower or higher than expected. Verify that the range includes every intended value and excludes totals, subtotals, and the answer cell. Check for zeros, hidden rows, or values stored as text. AVERAGE includes numeric values in hidden rows, so hiding a row does not remove its percentage from the calculation. If you want an overall rate, confirm that you used the counts-based weighted calculation rather than the simple mean.
You see #DIV/0!. AVERAGE returns this error when the selected range has no numeric values to average. Check that the cells contain real numbers or percentage values rather than text such as a number imported with an apostrophe. For a weighted rate, check that the sum of the totals is greater than zero before dividing.
The result has too many or too few decimal places. Change the display precision with Increase Decimal or Decrease Decimal on the Home tab. This changes what you see, not the value used in calculations. If the precise value itself must be rounded for a defined reporting rule, use an appropriate rounding formula only after confirming the required rule.
Frequently Asked Questions
What is the formula for averaging percentages in Excel?
For an ordinary mean, use =AVERAGE(range), replacing range with the cells containing your percentage values. For example, with percentages in C2:C6, use =AVERAGE(C2:C6), then format the result as a percentage.
Can I average percentages that are already formatted as percentages?
Yes. If Excel stores the cells as numeric percentage values, AVERAGE works normally. Formatting controls the display; it does not prevent Excel from using the underlying values in the calculation.
Should I use AVERAGE or a weighted average?
Use AVERAGE if each percentage represents an equally important observation. Use a weighted average if each percentage is based on a different number of cases and you want the combined rate. When you have the original counts, divide the sum of successes by the sum of totals.
Does AVERAGE include blank cells?
No. AVERAGE ignores blank cells and text in a referenced range, but it includes numeric zero values. Decide whether a zero represents a genuine 0% or missing information before including it.
How do I average percentages in different parts of a sheet?
You can provide separate ranges in one formula. For example, if the percentage values are in C2:C4 and E2:E4, use =AVERAGE(C2:C4,E2:E4). This treats every numeric value in both ranges equally; it does not weight groups by size.
Why does the average display as a decimal?
The underlying result is a decimal proportion, so 0.86 represents 86%. Select the result cell and apply Percentage or Percent Style. Avoid multiplying by 100 if you are also using percentage formatting.
Related
- How to Enable Track Changes in Excel
- Enable Scroll Lock in Excel: Keyboard and On-Screen Methods
- How to Enable the Share Option in Excel for Collaboration
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: Expand Print Area to Fit a PageTo make an Excel printout fit a page, select the cells you want, choose Page Layout > Print…
- How to Create a Professional Email Signature in OutlookTo create a proper signature in Outlook, open the signature settings for your version of Outlook, write a…
- Days Between Two Dates in Excel: A Simple GuideTo find the number of days between two dates in Excel, subtract the earlier date from the later…
- Reset Dropdowns in Google Sheets: Quick FixesTo reset a dropdown in Google Sheets, select the cell and press Delete or Backspace to clear its…
- Excel Page Break Shortcut: Insert, Remove, and ResetIn Excel for Microsoft 365 on Windows, press Alt+P, B, I to insert a page break: press the…
- Average in Excel: How to Calculate ItTo calculate an average in Excel, enter =AVERAGE(A2:A6) in an empty cell, replacing A2:A6 with the range that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.