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.

1. How To Count Less Than And Greater Than In Excel Example.

1. 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.
2. 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.
   

   	A	B	C	D	E	F
   1	Student Name	Score	Sex		Statistics
   2	Jerry	100	Male		Score less than	90
   3	Kate	90	Female		Score greater than	60
   4	Tom	80	Male
   5	Lily	60	Female
   6	john	70	Male
   7	Richard	80	Male
   8	Jackie	90	Female		Count	3

3. 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.
4. Because there are 3 cells ( B4, B6, B7 ) in the cell range B2:B8 match the criteria.
5. In the above formula, B2:B8 is the score number cell range, we will compare the criteria to this cell range numbers.
6. The criteria “<“&F2 are used to count the numbers ( in the above cell range ) that are less than the number in cell F2.
7. The criteria “>”&F3 are used to count the numbers ( in the above cell range ) that are greater than the number in cell F3.
8. If you want to count the number less than and equal to you can contact the string “<=” with the criteria cell number value.
9. If you want to count the number greater than and equal to you can contact the string “>=” with the criteria cell number value.

2. How To Count Less Than Or Greater Than In Excel Example.

1. Now we will use the excel function COUNTIF to count the cells that are less than or greater than the criteria.
2. Below are the example data cells.
   

   	A	B	C	D	E	F
   1	Student Name	Score	Sex		Statistics
   2	Jerry	100	Male		Score less than	80
   3	Kate	90	Female		Score greater than	90
   4	Tom	80	Male
   5	Lily	60	Female
   6	john	70	Male
   7	Richard	80	Male
   8	Jackie	90	Female		Count	3

3. 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.
4. The function COUNTIF only takes 2 parameters, the first parameter is the cell range, and the second parameter is the criteria.
5. The “<“ character will count the number that is less than the value, the “>” character will count the number that is greater than the value.
6. We plus the above 2 numbers to count the number that is less than or greater than the value.