The answer in the space provided is AVERAGEIF. This is a function in an excel that has the capability of categorizing the statistical function that is provided in the worksheet and in the same time, it calculates the average values with the given range.