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 GPA in Excel and Google Sheets
Excel & Google Sheets
=AVERAGE(B2:B4)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Course | Grade_Points |
| Math | 3.7 |
| English | 4.0 |
| History | 3.3 |
=AVERAGE(B2:B4)→3.6666666667
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 a lookup table mapping letter grades to grade points (e.g., A=4.0, B=3.0, C=2.0, D=1.0, F=0.0) in a separate area.
- 2Enter course names in column A and the numeric grade points (or letter grades) in column B.
- 3If you have letter grades, convert with VLOOKUP: =VLOOKUP(B2,$E$2:$F$6,2,0) to pull the numeric grade point.
- 4In a summary cell, use =AVERAGE(C2:C20) on the grade point column to get the GPA — or =ROUND(AVERAGE(C2:C20),2) to show two decimal places.
Tips
- Use SUMPRODUCT for a weighted GPA: =SUMPRODUCT(grade_points,credits)/SUM(credits) where each course has a different credit hour weight.
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
How do I exclude blank rows from my GPA calculation?
AVERAGE already ignores blank cells — only enter the grade point cells that have values and it calculates correctly.
What's the difference between a simple and weighted GPA?
A simple GPA averages all grade points equally; a weighted GPA multiplies each grade point by the course credit hours and divides by total credits.