COUNTIF Greater than, Less than, or Equal to
To count cells with values greater than, less than, or equal to the number you specify, you simply add a corresponding operator to the criteria.
Consider the student’s marks which are given below for and XYZ examination.
Understanding the arguments of the COUNTIF function in Excel
Understanding the argument of the COUNTIF function in Excel
Output:
Note: RED color cells are used for the reference that which cells would satisfy the given criteria. RED color doesn’t come in the output of COUNTIF.
The output of the marks of the students having greater than 80
Example 2:
Input |
Output |
Excel COUNTIF Function
The COUNTIF function in Excel is used to count the number of cells that match a single condition applied. It can include Dates, Numbers, and Texts. It uses various logical operators like <(Less Than), >(Greater Than), >=(Greater Than or Equal to), <=(Less Than or Equal to), =(Equals to), and <>(NOT) for matching the condition. It also uses some wildcards like * and ? for partial matching.