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.
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
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.