How to Count Cells with Values Greater than or Equal to

To count the number of cells that contain values greater than or equal to a number, you can use the COUNTIF function.

Formula:

= COUNTIF(Range, ">=Number")

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

To count the cells with values greater than or equal to "70256" in column C.

– Range: column C (C2:C8)

– ">=Number" (criteria): cells with a value greater than or equal to "70256"

= Countif(C2:C8, ">=70256")
There are 6 persons having the salary over or equal to $70,256.

Count Cells Greater than or Equal to

Leave a Reply