The Excel AVERAGEIF function is used to find the average value from a range of cells that meet certain criteria.
The syntax for the AVERAGEIF function is:
=AVERAGEIF(range, criteria, [average_range])
|Range||The range of cells you want to test|
|Criteria||The criteria the records have to meet to be included|
|Average_range||The range of values to average. This is optional and if omitted the function will average the first range|
The example below shows the AVERAGEIF function being used to find the average order amount by the company Carpet Kings.