Entering the Range Argument
In this tutorial we want to find the number of Sales Reps who sold more than 250 orders for the year.
The Range argument tells the COUNTIF function which group of cells to search when trying to find the specified criteria of " > 250 ".
Tutorial Steps
For help with these instructions, click on the image above.
- In the dialog box, click on the Range line.
- Drag select cells E3 to E9 on the worksheet to enter these cell references as the range to be searched by the function.
- Leave the dialog box open for the next step in the tutorial.
