For example, COUNTIF(A1:A10,”Trump”) will count the number of cells within the range A1:A10 that contain the text “Trump” It is used to count cells that include dates, numbers, or text. Let us use the comparison operator “greater than or equal to” with the COUNTIF COUNTIF The COUNTIF function in Excel counts the number of cells within a range based on pre-defined criteria. Example #3–“Greater Than or Equal to” With the COUNTIF Function Since the values in the cells B5, B11, B12, and B13 are greater than $6500, we get the respective incentive amounts in column C. Step 5: Drag the formula to the remaining cells, as shown in the following image. This implies that the value in cell B2 is less than $6500. In cell C2, the formula returns the output 0. So, we type zero at the end of the formula. Step 4: If the logical test is “false,” the incentives are 0. Step 3: The condition is that if the logical test is “true,” we calculate the incentives as B2*10%.