To count the number of cells that contain values less than or equal to a number, you can use the COUNTIF function.
Formula:
= COUNTIF(Range, "<=Number")
Example: To count how many persons' salary are less than or equal to $70,256
– Range: column C (C2:C8)
– "<=Number" (criteria): cells with a value less than or equal to "70256"
= COUNTIF(C2:C8, "<=70256")
There are 3 persons having the salary less than or equal to $70,256.
