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.
  1. About.com
  2. Computing
  3. Spreadsheets
  4. Excel How To Videos
  5. Entering the Average_range Argument for the Excel AVERAGEIFS Function

©2014 About.com. All rights reserved.