Excel > Functions

AVERAGEIFS Function

The Excel AVERAGEIFS function is used to find the average value from a range of cells that meet multiple criteria.

The syntax for the AVERAGEIFS function is:

=AVERAGEIFS(average_range, criteria_range, criteria, ...)

Argument	Purpose
Average_range	The range of values to average
Criteria_range	The range of cells you want to test
Criteria	The criteria the records have to meet to be included

The example below shows the AVERAGEIFS function being used to find the average order amount by the company Carpet Kings in the month of February.

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

Guides