Excel's AVERAGEIF function allows you to calculate the mean of a dataset that ... to work out the average salary of all males over the age of 35. AVERAGEIF and AVERAGEIFS aren't the only functions ...