=COUNTIF(A1:A10,"<" & B10)

for example, from A1 thru C20:

29
29
24
23
13
24
28
8
13
25 21.6 3
16 20.3 4
15 18.9 5
5 17 6
23 17 6
28 18.5 5
14 17.5 6
7 15.4 6
30 17.6 6
21 18.4 5
20 17.9 5

--
Gary''s Student - gsnu200838


"Nestor" wrote:

On col A1toA100 have number,from col B10 have the averages of last 10 numbers
AVERAGE(A1:A10).I cannot get a result on C10 from COUNTIF(A1:A10,"B10").
Can anyone help?
Nestor