However, if someone's salary was $0, this would be included in the average calculation ... males over the age of 35. AVERAGEIF and AVERAGEIFS aren't the only functions in Excel that calculate ...