AVERAGEIF Function of Excel helps us to find out the average of values that we want.

The only difference between AVBERAGEIF Function and AVERAGE Function is that the AVERAGE Function brings out the average of values and on the other hand AVERAGEIF brings out the average of specific values.

Previously In Excel Formulas: AGGREGATE Function in Excel?

To understand the same, lets take a look at the clear picture.

AVERAGEIF Function

As you can observe in the above image that we have taken product color and sales in reference to the product id.

Now let’s say that we want to take out the average but we only want the average of Rose gold color products.

So, to do the same, this is what we do:

Step1: Input the Formula

AVERAGEIF Function

The formula for the same is as follows:

=AVERAGEIF(

The formula requires range, criteria as well as average range.

AVERAGEIF Function

The range is the category which elaborates your specification. In the above example, if we want to take average sales of rose gold color product only then our range will be “color”.

AVERAGEIF Function

Criteria is basically where you add your specification in the formula.

AVERAGEIF Function

The average range is the range where the actual values exist i.e. the values of which we want our average.

AVERAGEIF Function

And the answer is 4071.429.

Same goes with the case of other categories as well.

For silver:

AVERAGEIF Function

The average of silver color product is 1200.

For Gold:

AVERAGEIF Function

The average of Gold color product is 3500.

So, to conclude:

AVERAGEIF Function

It’s easy, isn’t it?