Where AVERAGEIF tests one condition before calculating the ... salary of all males over the age of 35. AVERAGEIF and ...