Entering the Range Argument
In this tutorial we want to find the total sales for those Sales Reps who had more than 250 orders in the year.
The Range argument tells the SUMIF 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 D3 to D9 on the worksheet to enter these cell references as the range to be searched by the function.
Return to Index page
