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.
