How the AVERAGEIF Function Works
Related Tutorial: Text only version - Excel AVERAGE IF Function Quick Tutorial
The AVERAGEIF function combines the IF function and AVERAGE function in Excel. This combination allows you to find the average or arithmetic mean of those values in a selected range of data that meets specific criteria.
The IF portion of the function determines what data meets the specified criteria and the AVERAGE part calculates the average or mean.
AVERAGE IF looks for the specific criteria in one cell or field in the record and, if it finds a match, it averages that data or data in another specified field in the same record.
AVERAGEIF Step by Step Tutorial
This tutorial uses the AVERAGE IF function to find the average yearly sales for the East sales region in a set of data records.
Following the steps in the tutorial topics below walks you through creating and using the AVERAGE IF function seen in the image above to calculate average yearly sales.