Tools

Weighted grade calculator

Your average when assignments and exams count for different amounts. Nothing you type leaves your browser.

Enter grades as
Row 1
%
%
Row 2
%
%
Row 3
%
%
Row 4
%
%
Weights so far: 0%
Your entries are not saved or sent
Weighted average
0%
Enter a grade and a weight in at least one row.
Weights counted
0%
Grade × weight ÷ 100
0
Letter grade (a common scale; your school's may differ)

An estimate from the numbers you enter. Your syllabus and your teacher decide how your grade is worked out.

How to use the weighted grade calculator

  1. Choose Percent or Points. Use Percent if your gradebook shows each part as a percentage, such as 85%. Use Points if you have scores like 45 out of 50.
  2. Fill in one row for each assignment or category, with its grade and its weight from the syllabus, such as "Homework 20%". The name is optional and only helps you read the breakdown.
  3. Add or remove rows as you need. A row with a weight but no grade yet, such as a final you have not taken, is left out and listed as not graded yet.

The weighted average updates as you type, with a breakdown of what each row adds. Copy result gives you a plain text summary to paste into notes or a message.

How a weighted grade is worked out

Multiply each grade by its weight, add those up, and divide by the total of the weights:

Weighted average = (grade 1 × weight 1 + grade 2 × weight 2 + ...) ÷ (weight 1 + weight 2 + ...)

When the weights add up to 100, that last step is just dividing by 100. Here is a class with four parts:

PartGradeWeightGrade × weight ÷ 100
Homework92%20%18.4
Quizzes85%20%17
Midterm78%25%19.5
Final exam88%35%30.8
Total100%85.7%

A plain average of the four grades would be 85.75%. The weighted average is a little lower, 85.7%, because homework, the highest of the four grades, counts for only 20% of the course.

Grades in points

In Points mode each row's grade is points earned divided by points possible, times 100. Lab reports at 45 out of 50 are 90%. For example:

PartPointsPercentWeightAdds
Lab reports45 / 5090%30%27
Quizzes34 / 4085%30%25.5
Test70 / 10070%40%28
Total100%80.5%

Some classes have no percentage weights at all: your grade is simply all the points you earned divided by all the points possible. You can still use this calculator. Put the points possible for each part in its Weight box. A homework total of 180 out of 200 and exams at 255 out of 300 give (90 × 200 + 85 × 300) ÷ 500 = 87%, the same as 435 ÷ 500.

When the weights do not add up to 100

The calculator always divides by the weights you actually entered, so the result stays on the usual 0 to 100 scale. It also tells you the total and shows the other figure, grade times weight divided by 100, so you can choose the one that fits your situation.

  • Work still to come. Midway through a course, your final exam (35%) has no grade yet. The first three rows above add up to 18.4 + 17 + 19.5 = 54.9 points from 65% of the course. Dividing by 65 gives 84.46%, your average on the work done so far. Dividing by 100 gives 54.9%, which is what you would end on if everything still to come scored zero. The first is the useful one for knowing where you stand. To find what you need on the remaining work, try the final grade calculator with 84.46% as your current grade.
  • A typo in the weights. If your syllabus weights should add up to 100 but yours come to 95 or 110, check them against the syllabus first. The note under the result shows the total you entered.
  • Extra credit on top. If your class adds a bonus category on top of 100%, dividing by the full total would shrink its effect. In that case the grade times weight divided by 100 figure is the one that matches how the bonus is meant to work.

Letter grades

With Show a letter grade on, the result includes a letter on a widely used 10-point scale: A for 90 to 100, B for 80 to 89, C for 70 to 79, D for 60 to 69 and F below 60. The US National Center for Education Statistics uses the same cut-offs when it standardizes high school transcripts, while noting that grade information can "vary considerably among schools, districts and states".

So treat the letter as a guide. Your school may use plus and minus grades or different cut-offs, and some teachers round 89.5 up while others do not. Your syllabus is the final word.

Averaging courses by credits

At college or university, a course worth more credits usually counts for more in an overall average. To get a credit-weighted average of your course percentages, enter each course's percentage as the grade and its credits as the weight:

CourseGradeCreditsGrade × credits
Biology91%4364
Statistics84%3252
History76%3228
Total10844

844 ÷ 10 = 84.4%. The note under the result says it was worked out over 10% of weight, not 100%. With credits that is expected, so use the main result and ignore the divided-by-100 figure. This averages percentages. A GPA uses grade points instead, under your school's own rules.

Weighted average in Excel or Google Sheets

Put the grades in one column and the weights in the next, say grades in B2:B5 and weights in C2:C5, then use:

=SUMPRODUCT(B2:B5, C2:C5) / SUM(C2:C5)

Microsoft's help page says "The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays", and Google's says it "calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges". SUM adds the weights. With the four-part class above, SUMPRODUCT gives 8,570, SUM gives 100, and the result is 85.7, the same as this calculator.

One difference: Microsoft notes that SUMPRODUCT "treats non-numeric array entries as if they were zeros". An empty grade with a weight beside it still adds its weight to SUM, which pulls the average down. This calculator leaves such rows out, so delete the weight or keep that row outside the ranges.

The grade needed to pass

If you want to know what you need on the remaining work to pass or reach a target, work out your average so far here, then enter it in the final grade calculator with the weight of what is left and the passing grade from your syllabus.

Questions and answers

What is a weighted grade?

A grade where some parts count more than others. If the final exam is worth 35% and homework 20%, a point on the exam moves your grade more than a point on homework. The weighted average multiplies each grade by its weight before adding them up.

Do the weights have to add up to 100?

No. The calculator divides by the total of the weights you entered, so the result is still a percentage. It tells you when the total is not 100 and shows the grade times weight divided by 100 figure as well.

How do I enter a test I have not taken yet?

Fill in its weight and leave the grade empty. It is listed as not graded yet and left out, so the result is your average on the work graded so far.

How do I add extra credit?

If the extra credit raises a category, enter that category above 100%, or with more points earned than possible. If it is a separate bonus on top of the course, add it as its own row and use the grade times weight divided by 100 figure.

Can I use points instead of percentages?

Yes. Choose Points and enter points earned and points possible for each row. Each row is turned into a percentage before the weights are applied.

Is the letter grade the one my school uses?

Not necessarily. It uses a common 10-point scale (90 and above is an A). Many schools use plus and minus grades or other cut-offs, so check your syllabus.

How do I calculate a weighted average in Excel?

With grades in B2:B5 and weights in C2:C5, use =SUMPRODUCT(B2:B5, C2:C5) / SUM(C2:C5). The same formula works in Google Sheets.

Sources

Checked on 7 October 2026. If a rule has changed, please tell us.

More school tools

All school tools