How the COUNTIF Function Works-1

The COUNTIF function combines the IF function and COUNT function in Excel. This combination allows you to count the number of times specific data is found in a selected group of cells. The IF portion of the function determines what data meets the specified criteria and the COUNT part does the counting. 

We will use 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. Entering the Tutorial Data: The first step to using the COUNTIF function in Excel is to enter the data. Enter the data below into cells A1 to C5 of an Excel worksheet. The COUNTIF function and the search criteria (greater than 250 orders) will be added to row 6 below the data. Now let's do this 2geda. In cell A1, enter Sales Rep, A2=Dapo, A3=Jude A4=Austin, A5= Ade. B1=Regions, B2=North, B3=South, B4=East and B5=West. C1=#Orders, C2=265, C3=228, C4=267 and C5=261. In cell B6, type >250 and in cell C6, type COUNTIF(C2:C5,B6). If well recorded, C6 will return a value of 3 because the Orders by Sales Rep that is more than 250 are just 3. You can change the sign in C6 to <250...what do you have please? CIAO