1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel AVERAGEIF Function Step by Step Tutorial

By

1 of 8

How the AVERAGEIF Function Works
Excel AVERAGE IF Function

Excel AVERAGE IF Function

© Ted French

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.

Normally, AVERAGE IF is used with rows of data called records. In a record, all of the data in each cell in the row is related - such as a company's name, address and phone number.

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.

Tutorial Topics

©2014 About.com. All rights reserved.