The Excel AVERAGEIFS Function Kim 4 years ago Microsoft Tips Learn how to use the AVERAGEIFS function in Excel. This useful function enables you to average only specific cells based on criteria that you specify. Credit Technology for Teachers and Students