Entering the Criteria_range2 Argument
As mentioned previously, in this tutorial we are trying to match two criteria in each data record:
- Sales agents from the East sales region.
- Sales agents who have made more than 250 sales this year.
The Criteria_range2 argument indicates the range of cells the AVERAGEIFS is to search when trying to match the second criteria - sales agents who have sold more than 250 orders this year.
For help with these instructions, click on the image above.
- In the dialog box, click on the Criteria_range2 line.
- Drag select cells D3 to D9 in the worksheet to enter these cell references as the range to be searched by the function.