How to Count Cells with Values Less than

To count the number of cells that contain values less than a number, you can use the COUNTIF function, which will help you get the count of cells that are less than a particular value.


= COUNTIF(Range, "< number")


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

– The number is required, which is the base number.


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 less than $70,256

– Range: column C (C2:C8)

– "<Number" (criteria): cells with a value less than 70256

= Countif(C2:C8, "<70256")
There is 1 person having the salary less than $70,256.

Count Cells Less than

Leave a Reply