Adding the Search Criteria
The last step in the tutorial is to add the criteria we want the function to match.
In this case we want the number of Sales Reps with more than 250 orders for the year.
For help with these instructions, see the image above.
- In cell D12 type > 250 and press the Enter key on the keyboard.
- The number 4 should appear in cell E12.
- The criterion of " > 250 " is met in four cells in column E: E4, E5, E8, E9. Therefore these are the only cells counted by the function.
- When you click on cell E12, the complete function
=COUNTIF (E3:E9, D12) appears in the formula bar above the worksheet.