How To Count Less Than And / Or Greater Than In Excel

In this article, I will tell you how to use the Excel formula to count less than and/or greater than operations with examples.

Table of Contents

Because the Excel COUNTIFS function will return the number that matches both the multiple criteria, we will use the function COUNTIFS to implement this example.
Below are the example data cells. Column A contains the student’s name, column B contains the student’s score, and column C contains the student’s sex data.
Input the formula =COUNTIFS(B2:B8,”<“&F2, B2:B8,”>”&F3) in cell F8 and press the enter key, then it will display number 3 in cell F8.
Because there are 3 cells ( B4, B6, B7 ) in the cell range B2:B8 match the criteria.
In the above formula, B2:B8 is the score number cell range, we will compare the criteria to this cell range numbers.
The criteria “<“&F2 are used to count the numbers ( in the above cell range ) that are less than the number in cell F2.
The criteria “>”&F3 are used to count the numbers ( in the above cell range ) that are greater than the number in cell F3.
If you want to count the number less than and equal to you can contact the string “<=” with the criteria cell number value.
If you want to count the number greater than and equal to you can contact the string “>=” with the criteria cell number value.

Now we will use the Excel function COUNTIF to count the cells that are less than or greater than the criteria.
Below are the example data cells.
Input the formula =COUNTIF(B2:B8,”<“&F2)+COUNTIF(B2:B8,”>”&F3) in the cell F8, then it will display the number 3 in cell F8.
The function COUNTIF only takes 2 parameters, the first parameter is the cell range, and the second parameter is the criteria.
The “<“ character will count the number that is less than the value, and the “>” character will count the number that is greater than the value.
We plus the above 2 numbers to count the number that is less than or greater than the value.