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

excel averageIFs function example1

Related Posts

Average of Working Hours by Formula in Excel
EOMONTH function example

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
How to Average Ignore Zero Number 5

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
How to Calculate Average If Criteria Not Blank 11

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 STDEVP Function
excel stdevp examples2

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

Excel STDEVA Function
excel stdeva examples2

This post will guide you how to use the STDEVA function with syntax and examples in Microsoft excel. Description The Excel STDEVA function returns the standard deviation of a population based on a sample of numbers, text, and logical values. So ...

Excel STDEV Function
excel stdev examples2

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
excel slope examples2

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
excel rank examples1

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
excel quartile examples1

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
excel permut examples2

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