## Explanation

AVERAGEIF function lets us calculate the average of a range based on certain criteria.

## Syntax

The syntax of the AVERAGEIF function is as follows:

=AVERAGEIF(range,criteria,[average_range])

- range – This is the range in which our criteria will be checked.
- criteria – This is the criteria we’ll check
- [average_range] – This is the range for which we’d like to calculate the
__average__(only for the cells that matched our criteria).

It is important to note that [Average_range] is an optional argument, meaning we can skip it in certain cases. This happens when the **range **argument is the same as **average_range **argument**. **For example:

In this example, the B3:B9 range is used both for checking the criteria and calculating the average.

Note that we used the “>100000” to find the cells greater than 100,000. We can use the following operators as well:

<Less than

<=Less than or equal to

>=Great than or equal to

<>Not equal to

Don’t forget to use the quotation marks **” ” **when using these operators!

## Practice AVERAGEIF

Okay, now let’s practice the AVERAGEIF function!