Where AVERAGEIF tests one condition before calculating the ... salary of all males over the age of 35. AVERAGEIF and AVERAGEIFS aren't the only functions in Excel that calculate the average ...