Please enable JavaScript to view the comments powered by Disqus.


Count if less then a given criteria

The formula we use is COUNTIF(). In this formula we use logical operator of "<" to express the requirement of less then given criteria. This gives us the count for less then required criteria.

Used Functions

Category: Statistical

Counts the number of cells within a range that meet the given criteria


COUNTIF(range, criteria)

Lets chat on this