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!