The simplest way to average percentages

To find the average of a set of percentages in Excel, use the AVERAGE function the same way you would for any other numbers. Type =AVERAGE(, select the cells containing your percentages, then close the parenthesis and press Enter. Excel treats percentages as decimal values (50% as 0.5), so the math works correctly without any special steps.

The catch is that averaging percentages only works correctly when each percentage represents the same thing — like five test scores that are all out of 100 points. If your percentages come from different totals (for example, 80% of 50 items and 90% of 200 items), averaging the percentages directly gives you a wrong answer. In that case, you need to convert back to the original counts, average those, then convert to a percentage again.

Key Takeaways

  • Use =AVERAGE(cell range) to find the average of percentages that all represent the same total.
  • If your percentages come from different totals, convert each percentage back to a count, average the counts, then convert the result to a percentage.
  • Percentages formatted as 50% or 0.5 both work in the AVERAGE function — Excel handles the conversion automatically.
  • The SUMPRODUCT function can average percentages weighted by their original totals in a single formula.

When straightforward averaging works

straightforward averaging works when every percentage in your list is based on the same denominator. A classroom with five test scores (all out of 100 points) is the clearest example: if students scored 85%, 92%, 78%, 88%, and 95%, the average is 87.6%. Each percentage means the same thing, so adding them and dividing by five gives you a meaningful result.

The same logic applies to survey responses where the same number of people answered each question, or monthly performance metrics where each month covers the same time period. The key is that the "whole" each percentage represents is identical across all your data.

When you need to convert back to counts first

Imagine a sales team with two regions. Region A closed 16 deals out of 20 pitches (80%), and Region B closed 45 deals out of 50 pitches (90%). If you average 80% and 90%, you get 85%. But the team actually closed 61 deals out of 70 total pitches, which is 87.1% — not 85%.

The fix is to work backward from percentages to counts. Multiply each percentage by its original total to recover the number of successful outcomes, add those outcomes together, add the totals together, then divide. In the sales example: (0.80 × 20) + (0.90 × 50) = 16 + 45 = 61 deals. Then 61 ÷ 70 = 0.871, or 87.1%.

Set this up in Excel by creating a helper column. In one column, multiply each percentage by its total using a formula like =A2*B2 (where A2 is the percentage and B2 is the count). Then use SUM to add all the results, and divide by the sum of all the original totals.

Using SUMPRODUCT for weighted averages

If you want to average percentages weighted by their original totals in a single formula, use SUMPRODUCT. The formula looks like =SUMPRODUCT(percentages, totals) / SUM(totals). In the sales example, this would be =SUMPRODUCT(A2:A3, B2:B3) / SUM(B2:B3), where column A holds the percentages and column B holds the original counts.

SUMPRODUCT multiplies each percentage by its corresponding total, adds all those products together, then you divide by the sum of all totals. This gives you the correct weighted average in one step. It is faster than building a helper column, but the result is identical.

Formatting percentages so they display correctly

Excel stores percentages as decimals (0.5 for 50%), but you can display them either way. If your percentages are stored as decimals and you want them to show as 50% instead of 0.5, select the cells and click the percentage button in the toolbar, or right-click and choose Format Cells, then select Percentage.

The AVERAGE function works the same regardless of how percentages are displayed. A cell showing 50% and a cell showing 0.5 are identical to Excel — the difference is only visual. This means you can format your results as percentages without changing the underlying calculation.

Common mistakes and how to avoid them

The most common error is averaging percentages that come from different totals without converting back to counts first. Always ask yourself: does each percentage represent the same denominator? If not, use the conversion method or SUMPRODUCT.

A second mistake is forgetting that percentages entered as text (like "50%" typed into a cell as text rather than a number) will not calculate. If AVERAGE returns an error or zero, check that your percentages are formatted as numbers, not text. You can verify this by looking at how the numbers align in their cells — numbers align right, text aligns left.

A third mistake is mixing percentages and decimals without realizing it. If one column shows 0.5 and another shows 50%, they are the same value to Excel, but it is straightforward to misread. Keep your data consistent by formatting the entire range the same way before you calculate.

Step-by-step example with real numbers

Suppose you have three sales reps with different conversion rates from different numbers of calls. Rep A: 12 sales from 40 calls (30%). Rep B: 18 sales from 50 calls (36%). Rep C: 8 sales from 25 calls (32%). You want the team's overall conversion rate.

In column A, enter the percentages: 0.30, 0.36, 0.32. In column B, enter the call counts: 40, 50, 25. In a blank cell, type =SUMPRODUCT(A1:A3, B1:B3) / SUM(B1:B3). Press Enter. The result is 0.3348, or 33.48%. This is correct: 38 total sales from 115 total calls.

If you had straightforward averaged 30%, 36%, and 32%, you would get 32.67%, which is wrong because it treats each rep's performance equally even though they made different numbers of calls. The weighted average accounts for the fact that Rep B's higher rate came from more calls, so it should count more.

Frequently Asked Questions

Can I average percentages that are already in a cell as formulas?

Yes. The AVERAGE function works on the results of formulas, not just static numbers. If each cell contains a formula that calculates a percentage, AVERAGE will use those results. The source of the percentage does not matter — only the final value.

What if some of my percentages are negative?

AVERAGE handles negative percentages the same way it handles positive ones. A negative percentage (like -5%) is treated as -0.05 and included in the calculation normally. This is useful for tracking things like profit margin changes or performance variance.

Should I round the average percentage, and if so, how?

Rounding is a choice based on your needs, not a requirement. If you want to round to two decimal places, wrap your formula in ROUND: =ROUND(AVERAGE(A1:A10), 2). The second number (2) tells Excel how many decimal places to keep. For a percentage display, two decimal places is common, but one or zero may be appropriate depending on your context.

Can I average percentages across multiple sheets?

Yes. Reference cells from another sheet by typing the sheet name, an exclamation point, and the cell range: =AVERAGE(Sheet2!A1:A10). This works the same as averaging within a single sheet. If the sheet name contains spaces, wrap it in single quotes: =AVERAGE('Sheet 2'!A1:A10).

What is the difference between AVERAGE and AVERAGEIF?

AVERAGE calculates the mean of all cells in a range. AVERAGEIF calculates the mean of only the cells that meet a condition you specify. For example, =AVERAGEIF(A1:A10, ">50%") averages only percentages greater than 50%. Use AVERAGEIF when you want to exclude certain rows from the calculation.