FormulaCraft

How to calculate a weighted GPA in Excel and Google Sheets

Topic:RANK & statistical aggregates
Excel & Google Sheets
=SUMPRODUCT(B2:B4,C2:C4)/SUM(C2:C4)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

CourseGrade_PtsCredits
Calculus3.74
History4.03
Art3.32

=SUMPRODUCT(B2:B4,C2:C4)/SUM(C2:C4)→3.7111111111

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

Step by step

  1. 1Create three columns: Course Name (A), Grade Points (B, e.g. 4.0 for A), and Credit Hours (C, e.g. 3 or 4).
  2. 2In a summary cell, enter =SUMPRODUCT(B2:B20,C2:C20)/SUM(C2:C20) — this multiplies each grade point by its credit hours, sums the products, then divides by total credits.
  3. 3Format the result cell to 2 decimal places to display a standard GPA like 3.47.
  4. 4Add an IF guard for empty rows: =IFERROR(SUMPRODUCT(B2:B20,C2:C20)/SUM(C2:C20),0) to handle incomplete data.

Tips

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

Frequently asked

What's the difference between weighted and unweighted GPA?

Unweighted GPA uses =AVERAGE(B2:B20) treating all courses equally. Weighted GPA uses SUMPRODUCT to weight each course by its credit hours, giving heavier courses more influence.

How do I calculate cumulative GPA across multiple semesters?

Combine all semesters into one table and use the same SUMPRODUCT formula across all rows, or store semester totals and compute =SUMPRODUCT(total_points_per_sem)/total_credits_all_sems.

More on RANK & statistical aggregates

See all →
Reference

RANK.EQ

Returns the rank of a number in a list, assigning the same rank to ties (same as RANK). Essential for leaderboards.

How-to

How to rank values

Rank a number against a list with RANK — highest first or lowest first. Works the same in Excel and Google Sheets.

Reference

RANK.AVG

Returns the rank of a number, averaging ranks for ties. Useful in statistical analysis where tied ranks should not cluster.

How-to

How to calculate standard deviation

Measure how spread out your numbers are with STDEV for a sample or STDEVP for a whole population. Works in Excel and Google Sheets.

Reference

PERCENTILE

Returns the k-th percentile value from a dataset. Useful for performance benchmarking and threshold analysis.

How-to

How to calculate a weighted average

Combine values and their weights with SUMPRODUCT divided by the total weight. Works the same in Excel and Google Sheets.

Formulas used

SUMPRODUCTSUMAVERAGE

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: