countif

Syntax:

Value Number  countif(Range source, Number min, Number max)

Description:

Returns the number of numerical cells in source that are greater or equal than min and less or equal than max.

Examples:

($d4) = countif($a1:$c3, 2, 10)
Before:
AB CD
114-
2apple1.234
35%13
4
5
6
After:
AB CD
114-
2apple1.234
35%13
42
5
6
($a1) = countif($b1:$d20, $f1, $f2)