Count cells greater than

Count cells greater than

Related Functions

Sponsored Link

=COUNTIF(rng,">X")

To count the number of cells that have values greater than a particular number, you can use the COUNTIF function. In the generic form of the formula rng represents a range of cells that contain numbers, and X represents the threshold above which you want to count.

In the example shown, the active cell contains this formula:

 
=COUNTIF(C4:C10,">90")

Here’s how the formula works

COUNTIF counts the number of cells in the range that contain numeric values greater than X, and returns the result as a number.

If you want to count cells that are greater than or equal to 90, use:

 
=COUNTIF(C4:C10,">=90")

If you want to use a value in another cell as part of the criteria, use the ampersand (&) character to concatenate like this:

 
=COUNTIF(rng,">"&a1)

If the value in cell a1 is “70”, the criteria will be “>70” after concatenation.

Sponsored Link

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas
Logo