If you want to calculate the average based on a criteria,
then we have to use the AVERAGEIF formula.
The AVERAGEIF formula consists of three parts which are:
Range – the list of data that you want Excel to
find the Criteria in
Criteria – the item that you want Excel to find
in the Range
Average Range – the figures that you want Excel
to use to calculate the Average
So, for example, if you wanted the calculate the average
house prices based on the number of bedrooms, your range would be the list of
bedrooms each house has got. The criteria would be a specified number of
bedrooms and finally your Average Range would be the list of house prices.