Calculate Weighted Grades & GPA Instantly Free Online Tool

Weighted average shows up everywhere numbers matter more than others in the mix, from a final class grade where the exam counts more than a quiz, to a company's cost of capital where debt and equity carry different weights. Yet most guides only explain the textbook definition and stop there. This guide goes further. It walks through how to calculate weighted grades for a class, how to build the formula in Excel, how to work out a weighted GPA, and how the same core idea powers finance calculations like weighted average cost of capital, weighted average interest rate, and weighted average shares outstanding. Every section below includes a worked example, not just a definition, so you can apply the method to your own numbers immediately.

What a Weighted Average Actually Measures

A simple average treats every number the same. Three test scores of 70, 80, and 90 simply average to 80. A weighted average instead lets some numbers count more than others, based on a weight you assign, such as a percentage, a credit hour count, or a dollar amount. This distinction matters because most real grading systems, financial statements, and business metrics are not built on equal weighting. A final exam is rarely worth the same as a weekly quiz, and a bond that makes up 70 percent of a company's debt should influence the average interest rate far more than a bond that makes up 5 percent.

The Weighted Average Formula

General Formula

The general weighted average formula multiplies each value by its weight, adds those products together, then divides by the total of the weights. Written out: weighted average equals the sum of each value multiplied by its weight, divided by the sum of the weights. If weights are already expressed as percentages that add up to 100, the formula simplifies to the sum of each value multiplied by its percentage weight, expressed as a decimal.

Weighted Percentage Formula for Grades

For grades specifically, this becomes: weighted grade equals the sum of each assignment score multiplied by that assignment's percentage weight. If homework is worth 20 percent, quizzes 30 percent, and the final exam 50 percent, you multiply each category score by its percentage, then add the three results together to get the final weighted grade.

How to Calculate Weighted Grades for a Class Step by Step

1. List every graded category in the course, along with its official weight, exactly as stated in the syllabus.

2. Confirm the weights add up to 100 percent, since a syllabus sometimes lists weights that were updated mid-semester and no longer sum correctly.

3. Convert each category's raw score into a percentage of that category, not a raw point total, since categories often have different maximum points.

4. Multiply each category percentage by its weight, expressed as a decimal.

5. Add all the weighted category results together to get the final weighted grade percentage.

You can also skip the manual math with this grade calculator, which applies the same weighted formula instantly once you enter your category scores and weights.

A Worked Example: Calculating a Weighted Grade Percentage

Here is a worked scenario. Suppose homework is worth 20 percent and you scored 90 percent on homework overall. Quizzes are worth 30 percent, and you scored 82 percent. The final exam is worth 50 percent, and you scored 78 percent. The calculation runs as follows: 0.20 multiplied by 90 equals 18. Then 0.30 multiplied by 82 equals 24.6. Then 0.50 multiplied by 78 equals 39. Adding 18, 24.6, and 39 gives a final weighted grade of 81.6 percent.

A common mistake here is averaging the three category percentages directly, which in this example would incorrectly give 83.3 percent, ignoring the fact that the final exam carries far more weight than homework. Another mistake is applying the weight to raw points instead of the category percentage, which produces a wrong result whenever categories have different maximum point totals.

How to Calculate Weighted Average in Excel

Excel does not have a single built-in weighted average function, but the SUMPRODUCT function handles it cleanly in one formula. Place your scores in one column and the corresponding weights in an adjacent column. In an empty cell, enter a formula in this form: equals SUMPRODUCT of the scores range and the weights range, divided by the SUM of the weights range. SUMPRODUCT multiplies each score by its matching weight and adds the results, and dividing by the sum of weights normalizes the result even if your weights are not already expressed as clean percentages that add to 100.

A practical example: if column B holds category scores in cells B2 through B4 and column C holds weights in cells C2 through C4, the formula reads equals SUMPRODUCT open parenthesis B2 through B4, C2 through C4 close parenthesis, divided by SUM of C2 through C4. This single formula recalculates automatically the moment you update a score or a weight, which makes it far more reliable for tracking a live gradebook than recalculating by hand every week.

Microsoft's own documentation on calculating a weighted average in Excel walks through the SUMPRODUCT and SUM combination in more detail, including how to exclude specific rows from the calculation.

How to Calculate a Weighted GPA

A weighted GPA works on the same principle as a weighted grade, but the weight is usually the credit hours attached to each course rather than a percentage category. To calculate weighted GPA, convert each course's letter grade into grade points using your institution's scale, typically 4.0 for an A. Multiply each course's grade points by that course's credit hours. Add the results across every course for the term. Divide that total by the sum of all credit hours for the term. This produces a GPA where a 4-credit course influences the final number twice as much as a 2-credit course, which is exactly how most transcripts are actually calculated.

Some high schools also weight GPA by course difficulty, adding an extra point for an honors or advanced placement class on top of the standard grade point scale. This is a different kind of weighting layered on top of the credit hour weighting, and it explains why two students with the same letter grades can end up with different GPAs if one took more advanced courses. Always check whether your school reports weighted or unweighted GPA on official transcripts, since college applications sometimes ask for both numbers separately.

This GPA calculator handles the credit hour weighting automatically, and pairs well with the average calculator if you also want to compare a simple average against the weighted result.

Weighted Average in Finance: Cost of Capital, Interest Rate, Shares, Price, and Life

The same weighted average logic drives several core finance calculations, even though the vocabulary changes.

Weighted Average Cost of Capital

Weighted average cost of capital, commonly called WACC, blends the cost of a company's debt and the cost of its equity, weighted by how much of the company's financing comes from each source. If a company is financed 40 percent by debt at a 6 percent after-tax cost and 60 percent by equity at a 12 percent cost, the WACC is 0.40 multiplied by 6, plus 0.60 multiplied by 12, which equals 9.6 percent. This figure represents the minimum return a company's investments need to generate to satisfy both its lenders and its shareholders.

Weighted Average Interest Rate

Weighted average interest rate applies the same idea to a portfolio of loans or bonds with different balances and different rates. Instead of averaging the interest rates directly, you weight each rate by the outstanding balance it applies to. A borrower with a 50000 loan at 5 percent and a 20000 loan at 8 percent has a weighted average interest rate of 50000 multiplied by 5 plus 20000 multiplied by 8, divided by 70000, which works out to about 5.9 percent, not the simple average of 6.5 percent. This distinction genuinely matters when comparing total borrowing costs or deciding which debt to pay down first.

Weighted Average Shares Outstanding

Weighted average shares outstanding is used to calculate earnings per share when a company issues or buys back stock partway through a reporting period. Instead of using the share count on a single date, the calculation weights each share count by the portion of the period it was actually outstanding. A company that had 1,000,000 shares for the first half of the year and 1,200,000 shares for the second half, after a mid-year stock issuance, has a weighted average share count of 1,100,000 for that year, not simply the year-end figure.

The SEC's investor education glossary on earnings per share confirms this weighted average share count is the standard denominator companies use when reporting EPS.

Weighted Average Cost and Weighted Average Price

Weighted average cost and weighted average price follow the identical pattern in inventory and purchasing contexts. If a business buys 100 units at 10 dollars and later buys 50 units at 14 dollars, the weighted average cost per unit is 100 multiplied by 10 plus 50 multiplied by 14, divided by 150, which equals about 11.33 dollars per unit, not a plain average of the two prices. This weighted figure is what accounting standards require for inventory valuation under the weighted average cost method, since it reflects the actual mix of units on hand.

Weighted Average Life

Weighted average life, most often seen with bonds and amortizing loans, measures the average time it takes to receive each dollar of principal back, weighted by the size of each principal payment. A loan that returns most of its principal in the final years has a longer weighted average life than one that returns principal evenly, even if both loans have the same final maturity date. Lenders use this figure to compare the true timing risk of different debt instruments, not just their stated maturity.

Common Mistakes People Make When Calculating Weighted Averages

• Confusing a simple average with a weighted average, which quietly produces a wrong number any time the weights are not equal.

• Applying a weight to a raw score instead of a percentage, which breaks the calculation whenever categories have different maximum points.

• Letting percentage weights that should sum to 100 drift due to an outdated syllabus or a revised loan schedule, without checking the total first.

• Dividing by the count of items instead of the sum of the weights in Excel, which silently produces the wrong denominator.

• Averaging interest rates or unit costs directly without weighting by balance or quantity, understating or overstating the true blended figure.

Conclusion

Calculating a weighted average is a small formula with a large practical impact, whether you are figuring out a final class grade, building a live Excel gradebook, tracking a weighted GPA, or blending finance figures like cost of capital, interest rates, share counts, and inventory costs. The core method never changes: multiply each value by its weight, add the results, and divide by the total weight. Once you trust that formula and check your inputs against the mistakes covered above, the same calculation carries you from a classroom spreadsheet to a corporate finance model without missing a step.

For related calculations, the full library of free online calculators covers math, education, and finance tools built on the same verified formulas.

Frequently Asked Questions

Q: What is the fastest way to calculate a weighted average by hand?

Multiply each value by its weight, add the results together, then divide by the total of the weights. If the weights already sum to 100 percent, you can skip the final division step.

Q: How do you calculate weighted grades for a class without a syllabus breakdown?

Ask your instructor for the exact category weights, since guessing produces an unreliable result, and many institutions are required to publish this breakdown in the course syllabus.

Q: Does Excel have a dedicated weighted average function?

No. Excel does not include a single weighted average function, but the SUMPRODUCT function combined with SUM produces an accurate result in one formula.

Q: Is weighted GPA the same as unweighted GPA?

No. Weighted GPA typically factors in course difficulty or credit hours, while unweighted GPA treats every course on the same standard scale regardless of difficulty or credit load.

Q: Why does weighted average interest rate matter more than a simple average rate?

Because it reflects how much of your total debt sits at each rate, so a large balance at a high rate pulls the blended figure up more than a small balance at the same rate would.