countif when the criteria is a formula

N

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
 
G

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
 
N

Nestor

Thank you very much-great help.
Nestor

Gary''s Student said:
=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top