Entering the Average_range ArgumentThe 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.
For help with these instructions, click on the image above.
- Click on the Average_range line in the dialog box.
- 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.
- Click OK to close the dialog box and complete the AVERAGE IF function.
- 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).