If you wish to calculate GPA in Excel, please read this article. How to calculate GPA in Excel GPA doesn’t have a fixed scale and usually varies across universities.

How to make a conditional running total in Excel At this point, you’ve not really gained much; the PivotTable isn’t really any better than the Table and its simple expressions.