How to calculate GPA in Excel

Step 1: put the grade scale in cells, not in the formula

The sample uses a common 4.0 scale with plus and minus grades in F1:G10 (A = 4.0, A- = 3.7, B+ = 3.3 and so on). Scales differ between schools: some give A+ a 4.3, some have no minus grades, some use a 5.0 scale for honors classes. Copy the scale from your school's catalog or transcript key into these cells and every formula below follows it.

Keeping the scale in a table means you never edit a formula when the scale changes, and anyone checking your sheet can see exactly which points you used.

Step 2: look up the points for each grade

In D2, look up the letter grade in the scale and return its points. FALSE forces an exact match, which matters here: with approximate match, A- and A could be confused because the table is not sorted the way approximate match needs. The dollar signs lock the scale so you can fill the formula down to D6.

VLOOKUP is not case-sensitive, so a grade typed as "b+" still finds B+. A grade that is not in the table (a typo, or a P for pass) returns #N/A, which is useful: it tells you a row needs attention.

Step 3: the weighted GPA

GPA is quality points divided by credits. Quality points for one course are credits times grade points: a 4-credit B+ is 4 x 3.3 = 13.2. SUMPRODUCT multiplies the two columns row by row and adds the results, so the whole calculation fits in one cell.

Here the quality points total 53.0 over 15 credits.

Why AVERAGE gives the wrong answer

AVERAGE treats a 1-credit studio class the same as a 4-credit science course. In this term the A in Studio Art pulls the simple average up, because it counts as a full fifth of the grades even though it is only one fifteenth of the credits.

Use AVERAGE only if every course has the same credits. Otherwise use the SUMPRODUCT version.

Cumulative GPA: add this term to your record

To update a cumulative GPA, you need your previous total credits and previous GPA (both on your transcript). Turn the old GPA back into quality points by multiplying by the old credits, add this term's quality points, and divide by all the credits together. Averaging the old GPA and the term GPA would be wrong for the same reason as above: 45 earlier credits outweigh 15 new ones.

Prefer no helper column? In full Excel, =SUMPRODUCT(B2:B6,SUMIF(F2:F10,C2:C6,G2:G10))/SUM(B2:B6) looks up all the grades inside one formula. The helper column is easier to check, so it is the better choice for most people.

Round the result the way your school does

Wrap the GPA in ROUND(...,2) to show two decimals, or ROUNDDOWN(...,2) if your school truncates instead of rounding. A truncated 3.4999 is 3.49, a rounded one is 3.50, which can matter for honors cut-offs. If you only need it to look tidy, change the number format and keep the full value underneath.