Excel formula: Count cells greater than or less than

To count the cells greater than or less than a particular number, you can use the COUNTIF function to handle it.

Count cells greater than a particular value

Generic formula:

COUNTIF(range,criteria)

Example:

Count the number of cells that are greater than 35 from the Number List. Using this formula

=COUNTIF(B3:B8,E2)

Or

=COUNTIF(B3:B8,">35")

In above formula, B3:B8 is the range you will count cells from, E2 and “>35” are the criteria you want to count cells based on.

The press Enter key to get the counted result.

Tip:

If you want to count cells greater than or equal to a particular value, you can use this generic formula:

COUNTIF(range,”>=number”)

Take example: Count cells that greater than or equal to 32, using the formula:

=COUNTIF(B12:B17,">=32")

Count cells less than a particular value

Generic formula:

COUNTIF(range,criteria)

Example

Count the number of cells that are less than 50 from the Number List.

=COUNTIF(B3:B8,E2)

or

=COUNTIF(B3:B8,">50")

In above formula, B3:B8 is the range you will count cells from, E2 and “>50” are the criteria you want to count cells based on.

The press Enter key to get the counted result.

Tip:

If you want to count cells less than or equal to a particular value, you can use this generic formula:

COUNTIF(range,”>=number”)

Take example: Count cells that less than or equal to 59, using the formula

=COUNTIF(B12:B17,"<=59")

Sample File

Click to download sample file

---

Relative Formulas

• Count cells equal to
  With the COUNTIF function, you can count cells that equal to or not contain a specified value.
• Count cells that equal to x or y
  In some times, you may want to count the number of cells that meet one of two criteria, in this case, you can use the COUNTIF function.
• Count cells equal to x and y
  Here this article introduce the formula to count cells that at the meanwhile match two criteria.
• Count cells not equal to
  This article talks about how to use the COUNTIF function to count the number of cell that not equal to a specific value

---

Excel Productivity Tools