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.