# AVERAGEIF

## Content

This function calculates the average of the specified numeric values provided that they meet the specified criteria.

## Syntax

`AVERAGEIF(range, criteria, [average_range])`

## Arguments

<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">This function has these arguments:</span>

| <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Argument</span> | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Description</span> |
| -------- | ----------- |
| *<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">range</span>* | [Required] One or more cells to average, including numbers or names, arrays, or references that contain numbers. |
| *<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">criteria</span>* | [Required] The criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged. |
| *average\_range* | [Optional] The actual set of cells to average. If omitted, range is used. |

## Remarks

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

## Examples

`AVERAGEIF(A1:A10, "<5000")`
`AVERAGEIF(R1C1,R3C2,"<>0")`