Please enable JavaScript to view the comments powered by Disqus.


COUNTIF(...B4:B13,(..."<"&"35"))

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

Syntax

COUNTIF(range, criteria)

Lets chat on this