Correct Answer : AVERAGEIF
Explanation : The AVERAGEIF() function is used to calculate the average (arithmetic mean) of a range based on a true or false condition.Syntax :=AVERAGEIF(criteria_range, criterion, [average_range])
AVERAGEIF()