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.
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 in the worksheet to add these cell references to the dialog box.