# 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">This function has these arguments:</span>

| <span data-teams="true">Argument</span> | <span data-teams="true">Description</span> |
| -------- | ----------- |
| *<span data-teams="true">range</span>* | [Required] One or more cells to average, including numbers or names, arrays, or references that contain numbers. |
| *<span data-teams="true">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")`