Excel AverageIFS Function

This post will guide you how to use Excel AVERAGEIFS function with syntax and examples in Microsoft excel.

Table of Contents


The Excel AVERAGEAIFS function returns the average of all numbers in a range of cells that meet multiple criteria.

The AVERAGEIFS function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function.

The AVERAGEIFS function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.


The syntax of the AVERAGEIFS function is as below:

= AVERAGEIFS (average_range, criteria_range1, criteria1, [criteria_range2, criteria2],…)

Where the AVERAGEIFS function arguments are:
Average_range – This is a required argument. The range of cells that you want to average.
Criteria_range1  – This is a required argument. The range to apply the associated criteria.
Criteria – This is an optional argument. The criteria used to define which cells are averaged.


The below examples will show you how to use Excel AVERAGEIFS Function to return the average of all numbers in a range of cells based on multiple criteria.

#1 To get the average of all numbers in average range B1:B5 and meet the criteria that equal to “2015” in range A1:A5, and equal to “TRUE”in range C1:C5 , just using the following excel formula: =AVERAGEIFS(B1:B5,A1:A5,2015,C1:C5,”TRUE”)

excel averageIFs function example1

Related Posts

Average Of Numbers With Multiple Criteria In Excel

Have you ever come across a task to calculate the average of the numbers with respect to multiple criteria? Are you tired of doing this cumbersome task manually? Are you willing to do this task smartly in just a matter ...

Calculate Average Response Time Per Month In Microsoft Excel

Assume that you have been assigned a task of calculating the average response time per month in MS Excel, then; if you are new to MS Excel, doing this task manually might be your first attempt which would not only ...

Average of Working Hours by Formula in Excel

Suppose you are going to count the average working hours of employees in the company based on different months. If a worksheet including working hours on different dates and months is prepared for you, do you know how can we ...

How to Average Ignore Zero Number

AVERAGE function is a frequently used function in our office work. Except this basic function, Excel also provides some other Average related functions like AVERAGEIF, AVERAGEIFS. In this article, we will show you applying AVERAGEIF function to get average with ...

How to Calculate Average If Criteria Not Blank/Ignore Blank Cell

In daily work we often need to calculate the average of some numbers based on given conditions or criteria. To calculate average with criteria, we can apply AVERAGEIF of AVERAGEIFS function. AVERAGEIFS function can handle more than one group of ...


So empty here ... leave a comment!

Leave a Reply