Skip to content
Home
Tutorials
Real-World Examples
Count cells if less than
Update Formula
Parameters
Formula
Range Reference:
Specific Value:
enter the cell reference that contains the value that you want to count for if less than this value
Formula:
=
COUNTIF
(
C8:C14
,"<"&
C5
)
=
COUNTIF
(C8:C14,"<"&C5)