Calculating GPA in Excel is straightforward once you understand the formula, but there are a few variations — weighted vs. unweighted, cumulative vs. term GPA, different grading scales — that can trip you up. This guide covers all of them.
The GPA Formula
GPA is a weighted average of grade points, weighted by credit hours. For each course, multiply the grade points by the credit hours. Sum all of those products, then divide by total credit hours.
Grade points by letter grade (standard 4.0 scale): A = 4.0, A- = 3.7, B+ = 3.3, B = 3.0, B- = 2.7, C+ = 2.3, C = 2.0, C- = 1.7, D = 1.0, F = 0.0
Setting Up Your Grade Sheet
One row per course. Columns: course name, letter grade, credit hours, and grade points. Use VLOOKUP to convert letter grades to grade points automatically. Create a lookup table somewhere in the sheet:
=VLOOKUP(B2, GradeScale!A:B, 2, FALSE)
Where B2 is the letter grade and GradeScale is your grade-to-points table. This way you enter letter grades and Excel converts them — no manual entry of decimal grade points.
Calculating GPA
Term GPA:
=SUMPRODUCT(D2:D10, C2:C10) / SUM(C2:C10)
Where D is grade points and C is credit hours. SUMPRODUCT multiplies grade points by credit hours for each row and sums the results. Divide by total credit hours to get GPA.
Cumulative GPA Across Multiple Terms
Add a term column to your grade log and keep all terms in one flat table. Use SUMPRODUCT with SUMIFS logic — or simply keep a running total of quality points and credit hours:
Cumulative quality points: =SUMPRODUCT(D2:D50, C2:C50) Cumulative credit hours: =SUM(C2:C50) Cumulative GPA: =E52/E53
Where E52 is cumulative quality points and E53 is cumulative credit hours.
Class-Wide GPA Summary
If you're tracking grades for a whole class, add student name as a column and build a pivot table with student in Rows and GPA (calculated per student) in Values. This requires calculating GPA per student using SUMPRODUCT with SUMIFS — SheetXAI handles this much more easily than manually writing the nested formula.
The Easy Way: Using SheetXAI in Excel
Example 1: You have grade data already in the spreadsheet.
"I have a grade log with student name, course, letter grade, and credit hours. Calculate cumulative GPA for each student using a 4.0 scale, and build a class summary showing GPA distribution."
SheetXAI reads your data, sets up the grade scale lookup, calculates GPA per student, and builds the class summary.
Example 2: Your grade data comes from a student information system.
"Pull this semester's grades and credit hours from our SIS and calculate cumulative GPA for all students, flagged anyone below 2.0."
SheetXAI connects to your SIS and builds the full GPA report.
Try SheetXAI free and see what it builds for you.
Published May 2026. See also: How to Track Student Grades in Google Sheets, How to Make a Student Summary Report in Excel, and Google Sheets AI Guide.
