Exceljet

Quick, clean, and to the point

Count cells greater than

Excel formula: Count cells greater than
Generic formula 
=COUNTIF(rng,">X")
Explanation 

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")

How this 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.

Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.