Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate a weighted GPA in Excel and Google Sheets
Topic:RANK & statistical aggregatesExcel & Google Sheets
=SUMPRODUCT(B2:B4,C2:C4)/SUM(C2:C4)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Course | Grade_Pts | Credits |
| Calculus | 3.7 | 4 |
| History | 4.0 | 3 |
| Art | 3.3 | 2 |
=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
- 1Create three columns: Course Name (A), Grade Points (B, e.g. 4.0 for A), and Credit Hours (C, e.g. 3 or 4).
- 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.
- 3Format the result cell to 2 decimal places to display a standard GPA like 3.47.
- 4Add an IF guard for empty rows: =IFERROR(SUMPRODUCT(B2:B20,C2:C20)/SUM(C2:C20),0) to handle incomplete data.
Tips
- Use a grade lookup table and VLOOKUP in column B to convert letter grades (A, B+, C) to grade points (4.0, 3.3, 2.0) automatically, so you only enter the letter grade.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
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-toHow to rank values
Rank a number against a list with RANK — highest first or lowest first. Works the same in Excel and Google Sheets.
ReferenceRANK.AVG
Returns the rank of a number, averaging ranks for ties. Useful in statistical analysis where tied ranks should not cluster.
How-toHow 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.
ReferencePERCENTILE
Returns the k-th percentile value from a dataset. Useful for performance benchmarking and threshold analysis.
How-toHow 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.