How to Count Cells with Values Less than or Equal to

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.

Count Cells less than or equal to

Leave a Reply