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.

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

The formula for the same is as follows:

=AVERAGEIF(

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

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”.

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

Same goes with the case of other categories as well.

For silver:

The average of silver color product is 1200.

For Gold:

The average of Gold color product is 3500.

So, to conclude:

It’s easy, isn’t it?