1. Computing

Excel AVERAGEIFS Function Step by Step Tutorial

By

1 of 10

How the AVERAGEIFS Function Works
Excel AVERAGEIFS Function Tutorial

© Ted French

Excel AVERAGEIFS Function Tutorial

How the AVERAGEIFS Function Works

Related Tutorial: Text only version - Excel AVERAGEIFS Function Quick Tutorial

The AVERAGEIFS function extends the usefulness of the AVERAGEIF function by allowing you to set conditions on two or more ranges of data rather than just one as in AVERAGEIF.

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

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.

Tutorial Topics

©2014 About.com. All rights reserved.