# AVERAGEIFS

## Content

This function calculates the average of all cells that meet multiple specified criteria.

## Syntax

`AVERAGEIFS(value1, condition1, value2, ..., condition2...)`

`AVERAGEIFS(array, condition)`

`AVERAGEIFS(array1, array2, ..., condition)`

## Arguments

Each argument can be a double-precision floating-point value, an integer value, or an array (cell range). Up to 255 arguments may be included. 
You can use a single array (cell range) instead of a list of values. 
You can use multiple arrays (cell ranges) as well. 
You can have up to 127 arguments for the conditions.

## Remarks

This is a measure of the variability in a data set.

## Data Types

Accepts numeric data. The condition accepts text, numeric, or expression data. Returns numeric data.

## Examples

`AVERAGEIFS(B2:B5,B2:B5,">90",B2:B5,"<100")`

`AVERAGEIFS(R1C1,R3C2,"<>0")`