Entering the Criteria Argument
In this example if data in the range D3:D12 is greater than 250 then the total sales for that record will be added by the SUMIF function.
Although actual data - such as text or numbers like " > 250 " can be entered into the dialog box for this argument it is usually best to add the data to a cell in the worksheet and then enter that cell reference into the dialog box.
Tutorial Steps
For help with these instructions, click on the image above.
- Click on the Criteria line in the dialog box.
- Click on cell E13 to enter that cell reference. The function will search the range selected in the previous step for data that matches this criteria (North).
Cell References Increase Function Versatility
If a cell reference, such as E12, is entered as the Criteria Argument, the SUMIF function will look for matches to whatever data has been typed into that cell in the worksheet.
So after finding the total sales for Sales Reps with more than 250 orders it will be easy to find the total sales for other order numbers - such as less than 100 - simply by changing" > 250 " to " < 100 ". The function will automatically update and display the new result.
Return to Index page
