AVERAGEIFS function returns the average of all cells in a range that meet multiple criteria.
= AVERAGEIFS (average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)average_range - The range of cells too average.
criteria_range1, criteria_range2 - Range of cells to check the associated criteria.
criteria1, criteria2 - Criteria by which you want to filter cells.
Calculate an average number of hours worked by male workers who are less than 60 years old.