What is the formula for calculating average percentage?

Simple average: (P1 + P2 + ... + Pn) / n. Weighted average: (P1×W1 + P2×W2 + ... + Pn×Wn) / (W1 + W2 + ... + Wn), where W represents the weight or base size for each percentage. Use the simple formula when all groups are the same size; use the weighted formula when they differ.

When should I use weighted average instead of simple average for percentages?

Use a weighted average whenever the underlying groups have different sizes. Examples: averaging profit margins across divisions with different revenues, averaging test scores when tests have different numbers of questions, averaging survey response rates across groups of different sizes, or averaging tax rates across income brackets. If you simply add percentages and divide, you will get a misleading result when group sizes differ.

Can you simply average two percentages?

Only if both percentages apply to equal-sized groups. For example, if a team scored 80% on Test 1 (10 questions) and 60% on Test 2 (10 questions), the average is (80+60)/2 = 70%. But if Test 1 had 10 questions and Test 2 had 40 questions, the simple average is wrong — you must use a weighted average: (0.80×10 + 0.60×40) / (10+40) = 64%.

How do I calculate the average of percentages in Excel?

For a simple average of percentages in Excel: =AVERAGE(A1:A10). For a weighted average: =SUMPRODUCT(percentages_range, weights_range)/SUM(weights_range). If your percentages are formatted as decimals (0.80 instead of 80), the formulas still work — the result will also be a decimal, which you can format as a percentage.

Average Percentage Calculator

Use this free average percentage calculator to find the simple or weighted average of any set of percentages instantly. Enter your values below — add as many rows as you need.

Percentage (%)

Weight / Base Size

Try another calculator

🔢

Percentage of Number Find X% of any value

🔄

Percentage Change Increase or decrease

📈

Percentage Increase How much did it grow?

Recent Calculations

How to Calculate Average Percentage

There are two methods for calculating percentage average, and choosing the wrong one is one of the most common mistakes in data analysis. The right method depends on whether the percentages all apply to groups of the same size.

Method 1: Simple Average (Equal Groups)

When every percentage applies to the same number of items — same class size, same sample size, same number of questions — you can calculate the average percentage by adding all values and dividing by the count.

Simple Average % = (P₁ + P₂ + … + Pₙ) ÷ n

Example: A student scores 70%, 85%, and 90% on three tests, each with the same number of questions.
Average = (70 + 85 + 90) ÷ 3 = 81.67%

Method 2: Weighted Average (Unequal Groups)

When the percentages apply to groups of different sizes, a simple average gives a misleading result. You must use a weighted average percentage — multiply each percentage by its group size, sum the products, then divide by the total group size.

Weighted Average % = (P₁×W₁ + P₂×W₂ + … + Pₙ×Wₙ) ÷ (W₁ + W₂ + … + Wₙ)

Example: Group A (100 people) has a 20% pass rate. Group B (400 people) has a 60% pass rate.
Weighted average = (20×100 + 60×400) ÷ (100+400) = (2,000+24,000) ÷ 500 = 52%
Simple average would give (20+60)÷2 = 40% — which is wrong.

⚠️ The most common mistake: Simply averaging percentages that apply to different-sized groups. A company with two divisions — one with $1M revenue at 10% margin, and one with $9M revenue at 30% margin — does not have a 20% average margin. The correct weighted answer is (10×1 + 30×9) ÷ (1+9) = 28%. Use the Weighted Average tab whenever group sizes differ.

How to Calculate Average Percentage in Excel

Simple average in Excel: =AVERAGE(A1:A5) where A1:A5 contains your percentages.
Weighted average in Excel: =SUMPRODUCT(A1:A5, B1:B5)/SUM(B1:B5) where column A has percentages and column B has weights.
Both formulas work identically in Google Sheets. Format the result cell as a percentage to display correctly.

Average Percentage Examples

Click any example to load it into the calculator.

Test scores: 70%, 85%, 90%

81.67%

Simple average — equal tests

4 scores: 60, 72, 88, 94%

78.50%

Simple average

20% (n=100), 60% (n=400)

52.00%

Weighted — different groups

10% ($1M), 30% ($9M)

28.00%

Weighted profit margin

5 test scores

86.40%

Simple average

3 groups, different sizes

27.13%

Weighted average

Real-World Scenarios

Student grades: A student scores 78%, 92%, and 85% on three equal-weight tests. The average percentage is (78+92+85) ÷ 3 = 85%. But if the first test had 20 questions, the second 50, and the third 30, the weighted average is (78×20 + 92×50 + 85×30) ÷ (20+50+30) = 87.1%. This is why school GPA systems weight credits — not all courses are equal. Understanding this also applies to finding a percentage of a number, since each weighted score is a percentage applied to a specific base.

Business margins: A company has three product lines with gross margins of 40%, 60%, and 25%. If all three generate equal revenue, the simple average margin is 41.67%. But if they generate $100k, $500k, and $200k respectively, the weighted average is (40×100 + 60×500 + 25×200) ÷ 800 = 51.25%. The weighted figure is what matters for overall financial reporting. For calculating each product line's margin individually, use the gross profit margin calculator.

Survey response rates: A survey goes to three regions: Region A (500 people, 30% response rate), Region B (1,200 people, 45% response rate), Region C (300 people, 55% response rate). Simple average: (30+45+55)÷3 = 43.3%. Weighted average: (30×500 + 45×1200 + 55×300) ÷ 2000 = 42.75%. The difference is small here, but with more divergent group sizes it can be significant — always use the weighted method when reporting overall response rates across differently-sized cohorts.

When to Use an Average Percentage Calculator

Academic & Education

Average test scores, assignment grades, or class performance percentages. Use simple average when all assessments carry equal weight; use weighted average when they carry different credit values or question counts.

Business Performance

Average profit margins, conversion rates, or error rates across departments or product lines of different sizes. The weighted average percentage calculator gives the true company-wide figure rather than a misleading arithmetic mean.

Finance & Investing

Average portfolio returns across positions of different sizes, average interest rates across loans of different balances, or average tax rates across income brackets. All require weighted averaging to produce meaningful results.

HR & Survey Analysis

Average employee satisfaction scores, response rates, or completion rates across teams or locations of different sizes. Using a simple average when team sizes vary significantly will skew results toward smaller teams.

Manufacturing & Quality

Average defect rates, yield rates, or pass rates across production batches of different sizes. A batch of 10,000 units carries far more weight than a batch of 100 units when calculating the true overall defect rate.

Healthcare & Research

Average treatment success rates, test positivity rates, or survival rates across patient cohorts of different sizes. Clinical reporting standards almost always require weighted averaging when combining data from multiple study groups.

Frequently Asked Questions

How do you calculate average percentage?

For equal-sized groups: add all percentages and divide by the count. Example: (70 + 85 + 90) ÷ 3 = 81.67%. For unequal groups: multiply each percentage by its group size, sum the products, and divide by the total size — this is a weighted average percentage. Use the Simple Average tab above for the first method and the Weighted Average tab for the second.

How do I calculate average percentage in Excel?

Simple average: =AVERAGE(A1:A5). Weighted average: =SUMPRODUCT(A1:A5,B1:B5)/SUM(B1:B5) where column A has percentages and column B has weights. Both formulas work in Google Sheets too. If your percentages are stored as decimals (0.70 instead of 70), the formulas still work — format the result cell as a percentage to display it correctly.

When should I use weighted average instead of simple average percentage?

Use weighted average whenever the percentages apply to groups of different sizes. Common cases: averaging profit margins across divisions with different revenues, test scores when tests have different question counts, response rates across populations of different sizes, or interest rates across loans of different balances. If every group is exactly the same size, simple and weighted average give identical results.

Can you just add percentages and divide to get the average?

Only if every percentage applies to the same-sized group. If Group A (10 people) has a 20% pass rate and Group B (90 people) has a 80% pass rate, the simple average gives (20+80)÷2 = 50% — which is wrong. The weighted average is (20×10 + 80×90)÷(10+90) = 74%, which correctly reflects that Group B was nine times larger. Simply adding and dividing is one of the most common errors in percentage analysis.

What is a weighted average percentage?

A weighted average percentage accounts for the fact that different percentages may apply to groups of different sizes. Each percentage is multiplied by its group size (the weight), the products are summed, and the total is divided by the sum of all weights. This gives the true overall percentage across all groups combined, rather than an equal-weight average that ignores group sizes.

How do I calculate average percentage of percentage?

This always requires a weighted average. For example, if 30% of Group A (200 people) passed and 70% of Group B (800 people) passed, the overall pass rate is not (30+70)÷2 = 50%. It is (30×200 + 70×800) ÷ (200+800) = 62%. Use the Weighted Average tab in the average percentage calculator above — enter the percentage in column 1 and the group size in column 2.

How many percentages can I average with this calculator?

There is no limit. Click the "+ Add another percentage" button to add as many rows as you need. The calculator handles any number of values for both simple and weighted averaging. For very large datasets (hundreds of rows), an Excel or Google Sheets formula may be more practical — use =AVERAGE() for simple or =SUMPRODUCT()/SUM() for weighted.

How is average percentage different from percentage change?

Average percentage combines multiple existing percentages into a single representative value. Percentage change measures how much a single value has increased or decreased relative to its original. They answer different questions: "what is the average of these rates?" versus "by how much did this value change?" For the latter, use the percentage change calculator.

Related Percentage Calculators

Need a different type of percentage calculation? Try one of our other free tools: