You need to use this formula to calculate the average GPA in Excel: =<cell with sum of grade values>/<total number of subjects>. Then, you can use VLOOKUP to enter the grades.

GPA gets calculated differently in many schools and colleges. Therefore, it is hard to determine where you failed in assessment with other applicants. The first step is to learn how to calculate GPA.

In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.