1. Computing

Excel AVERAGEIFS Function Step by Step Tutorial

By

5 of 10

Entering the Average_range Argument
Entering the Average_range Argument

Entering the Average_range Argument

© Ted French

Entering the Average_range Argument

The Average_range argument contains the cell references to the data we want to average.

When the function finds a match between all of the specified Criteria and Criteria_range arguments for a record the Average_range field for that record is included in the average.

In this tutorial the data for the Average_range argument is located in the Total Sales column.

Tutorial Steps

For help with these instructions, click on the image above.

  1. Click on the Average_range line in the dialog box.

  2. Drag select cells E3 to E9 in the worksheet to add these cell references to the dialog box.

©2014 About.com. All rights reserved.