How the COUNTIF Function Works
Related Tutorial: Text only version - Excel COUNTIF Function
The IF portion of the function determines what data meets the specified criteria and the COUNT part does the counting.
COUNTIF Function Step by Step Tutorial
This tutorial uses a set of data records and the COUNTIF function to find the number of Sales Reps who have more than 250 orders for the year.Following the steps in the tutorial topics below walks you through creating and using the COUNTIF function seen in the image above to count the number of sales reps with more than 250 orders.