Excel AVERAGEIF Function Step by Step Tutorial

By Ted French, About.com Guide

Entering the Average_range Argument

The Average_range argument is the group of cells that the function is to average when it finds a match in the Range argument identified in step 5 of the tutorial.

This argument is optional and, if omitted, Excel averages the cells that are specified in the Range argument.

Since we want the average sales for the East sales region we use the data in the Total Sales column as the Average_range argument.

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 on the spreadsheet. If the criteria specified in the previous step matches any data in the first range (C3 to C9), the function will average the data in the corresponding cells in this second range of cells.


3. Click OK to close the dialog box and complete the AVERAGE IF function.


4. A #DIV/0! error will appear in cell E12 - the cell where we entered the function because we have not yet added the data to the Criteria field (D12).

Previous

• How the AVERAGEIF Function Works
• Entering the Tutorial Data
• The AVERAGEIF Function's Syntax
• Starting the AVERAGEIF Function
• Entering the Range Argument
• Entering the Criteria Argument
• Entering the Average_range Argument
• Adding the Search Criteria

Next