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.
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:
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”.
Criteria is basically where you add your specification in the formula.
The average range is the range where the actual values exist i.e. the values of which we want our average.
And the answer is 4071.429.
Same goes with the case of other categories as well.
The average of silver color product is 1200.
The average of Gold color product is 3500.
So, to conclude:
It’s easy, isn’t it?