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:
A
B
C
D
1
1
4
-
2
apple
1.234
3
5
%
13
4
5
6
After:
A
B
C
D
1
1
4
-
2
apple
1.234
3
5
%
13
4
2
5
6
($a1) = countif($b1:$d20, $f1, $f2)