How to Count Cells with Values Greater than

The COUNTIF function is to help you get the count of cells that are greater than a particular value.

Formula:

= COUNTIF(Range, ">Number")

Explanations:

– The range is required, the range of cells you want to count;

– ">Number" is required, which is the base number.

Cautions:

The COUNTIF function can count the range of cells with a single criterion. When there are 2 or more criteria, please refer to the COUNTIFS function.

Example: To count how many persons' salary are over $70,256

Salary numbers are in column C, so to count the cells with values greater than "70256" in column C.

– Range: column C (C2:C8)

– ">Number" (criteria): cells with a value greater than 70256

= COUNTIF(C2:C8, ">70256") There are 4 persons having the salary over $70,256.

Count Cells Greater than

Leave a Reply