Excel > Functions

AVERAGEIF Function

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])

Argument	Purpose
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.

Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.

Guides