How to calculate average GPA in Excel? You need to use this formula to calculate the average GPA in Excel: =<cell with sum of grade values>/<total number of subjects>.

For example, you might need to calculate only the number of checks over a certain dollar amount or paychecks related to particular people. In these cases, you'll need to use COUNTIF and COUNTIFS.