# Excel AverageIFS Function

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

### Description

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.

### Syntax

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.

### Example

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”) 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 ...

Excel STDEV Function

This post will guide you how to use the STDEV function with syntax and examples in Microsoft excel. Description The Excel STDEV function returns the standard deviation of a population based on a sample of numbers. This function has been replaced ...

Excel SLOPE Function

This post will guide you how to use the SLOPE function with syntax and examples in Microsoft excel. Description The Excel SLOPE function returns the slope of the linear regression line through data points in known_y's and know_x's. So you can ...

Excel RANK Function

This post will guide you how to use the RANK function with syntax and examples in Microsoft excel. Description The Excel RANK function returns the rank of a given number in a supplied range of cells.  If there are duplicated values ...

Excel QUARTILE Function

This post will guide you how to use the QUARTILE function with syntax and examples in Microsoft excel. Description The Excel QUARTILE function returns the quartile from a supplied range of values. This function has been replaced with QUARTILE.EXC function and ...

Excel PERMUT Function

This post will guide you how to use the PERMUT function with syntax and examples in Microsoft excel. Description The Excel PERMUT function returns the number of permutations for a given number of items. The PERMUT function is a build-in function ...

Sidebar