countif when the criteria is a formula

[Nestor]

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

 

[Gary''s Student]

=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

 

[Stefi]

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

Regards,
Stefi

„Nestor†ezt írta:

 

[Nestor]

Thank you very much-great help.
Nestor

=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