GPA Calculator Excel Template
Calculate your GPA instantly — and see the exact Excel SUMPRODUCT formula to recreate it in your own spreadsheet.
Interactive GPA Calculator
| Course | Grade | Credits | Points | |
|---|---|---|---|---|
| 12.0 | ||||
| 9.9 | ||||
| 14.8 | ||||
| 9.0 |
Total Credits: 13
GPA: 3.52
The Excel Formulas to Build This
If grades (as points) are in column B and credit hours in column C, starting from row 2:
Weighted GPA (SUMPRODUCT)
=SUMPRODUCT(B2:B10, C2:C10) / SUM(C2:C10)Total credits
=SUM(C2:C10)Total grade points
=SUMPRODUCT(B2:B10, C2:C10)Tip: Use a lookup table to convert letter grades to points automatically with VLOOKUP.
How to Build a GPA Calculator in Excel
A GPA (Grade Point Average) is calculated by multiplying each course's grade points by its credit hours, summing the results, and dividing by total credits. This is called a weighted average — and SUMPRODUCT is the perfect Excel function for it.
Setting Up Your Excel GPA Spreadsheet
- Column A: Course name
- Column B: Grade points (A=4.0, B=3.0, etc.)
- Column C: Credit hours
- Column D: =B2*C2 (quality points per course)
- GPA: =SUM(D2:D10)/SUM(C2:C10)
Convert Letter Grades to Grade Points Automatically
Create a lookup table on a separate sheet:
=VLOOKUP(A2, GradeLookup!$A:$B, 2, 0)Frequently Asked Questions
How do I calculate GPA in Excel?
Use =SUMPRODUCT(grade_points, credit_hours) / SUM(credit_hours). This gives the weighted GPA.
What is a GPA calculator Excel template?
A spreadsheet with formulas pre-built to calculate weighted GPA from course grades and credit hours.
How do I get the Excel template?
Subscribe to our mailing list via the Resources page to download our free Excel GPA template.