Any time you use logical operators ... 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.