How the AVERAGEIFS Function Works
Related Tutorial: Text only version - Excel AVERAGEIFS Function Quick Tutorial
AVERAGEIFS looks for specific criteria in two or more fields in the record and only if it finds a match for each field specified is the data for that record included in the average.
AVERAGEIFS Step by Step Tutorial
In the AVERAGEIF step by step tutorial we averaged the sales for all sales agents in the East sales region for the past year.
In this tutorial we will set a second condition using AVERAGEIFS and only average those sales agents in the East sales region who have made more than 250 sales in the past year.
Following the steps in the tutorial topics below walks you through creating and using the AVERAGEIFS function seen in the image above.