Quick answer

A weighted average percentage equals the sum of (weight × percentage) for every row, divided by the sum of the weights. Equal weights reduce it to the ordinary mean.

Formula

  • Weighted % = (Σ wᵢpᵢ) ÷ (Σ wᵢ)
  • Check: if all wᵢ are equal, weighted % = simple average of pᵢ

Introduction

Weights show up the moment “every row counts the same” stops being true: a final exam worth half the course, a product line that drives most revenue, or a KPI leadership watches more closely than the rest. The Average Percentage Calculator still shines for the equal-weight baseline; this article is for when you must bake in those priorities explicitly.

Start from comparable percentages on the same scale. Weights steer how much each value moves the headline; they do not fix mixing unlike denominators.

What is it?

It is a single summary percent built from several percentages, where each value is multiplied by how much it should matter before you combine them. Policy sets the weights; the formula only combines them consistently.

If you only need the simple mean for peer metrics, stay with the homepage tool and how to calculate an average percentage instead.

Formula

  • For rows i = 1…n with percentages pᵢ and weights wᵢ > 0:
  • Weighted average = (w₁p₁ + w₂p₂ + … + wₙpₙ) ÷ (w₁ + w₂ + … + wₙ)
  • Spreadsheets: SUMPRODUCT(values, weights) ÷ SUM(weights) when columns align.

Weights can be shares that sum to 100%, point values, or counts, as long as every wᵢ is positive and paired with the right pᵢ. For contrast with the equal-weight case, see average percentage vs weighted average.

Step-by-step guide

  1. Confirm comparability. Each pᵢ should measure the same kind of outcome on the same percent scale. If rows are not peers, stratify or aggregate from raw counts before you weight.
  2. List pᵢ and wᵢ side by side. Write weights exactly as the policy states. Converting to decimals (0.4 for 40%) is fine if you stay consistent for every row.
  3. Compute each product wᵢpᵢ. Multiply weight by percentage for every included row. Partial rows or missing weights are policy questions. Resolve them before summing.
  4. Sum products and sum weights. Numerator = Σ(wᵢpᵢ). Denominator = Σwᵢ. Double-check that no row was skipped accidentally.
  5. Divide and interpret. The quotient is your weighted percentage. Compare it to the simple mean of the same pᵢ values to see how influence shifted the headline. If the weighted figure still misleads readers, pause and read when you should not average percentages before publishing.

Example

Three assignment categories report 82%, 91%, and 74% with weights 20%, 30%, and 50% (of the grade). Convert to decimals if you like: 0.2·82 + 0.3·91 + 0.5·74 = 16.4 + 27.3 + 37 = 80.7. Weights sum to 1.0, so the weighted average is 80.7%.

The simple mean of 82, 91, and 74 is about 82.33%, higher because the lowest score carried the most weight in the syllabus. Naming both numbers on a slide prevents someone from checking the wrong one in their head. To automate products and sums, averaging percentages in Excel and Google Sheets covers SUMPRODUCT patterns that match this math.