COUNTIF(...)
Count if less then a given criteria
Used Functions
Category: Statistical
Counts the number of cells within a range that meet the given criteria
Syntax
COUNTIF(range, criteria)
Practice COUNTIF Formula at Sheetzoom
COUNTIF formula at Microsoft help
0
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.