and your aim is to work out the average salary of all males over the age of 35. AVERAGEIF and AVERAGEIFS aren't the only functions in Excel that calculate the average of a dataset. For example ...