COUNTIF greater than AVERAGE

[Shoey68]

Hi all,

Apologies is this is just my stupidity, but I have a range of numbers which I need to find the average of, then count how many are higher (or lower) than the average.

I've found the average using the AVERAGE function anf have tried various methods to count how many are above average. Something like:
C11 =AVERAGE(A2:A10)
C12 =COUNTIF(A2:A10,">C11")

This is the closest I've got but can only mange a 0 as a result - I think it's not recognising the C11 as a numerical value???

Thanks for your time guys

 

[Juan Pablo González]

You were very close

=COUNTIF(A2:A10,">"&C11)

 

[jeffreybrown]

Try...

=COUNTIF(A2:A10,">"&C11)

 

[Haseeb Avarakkan]

Hello,

Just change your formula to,

=COUNTIF(A2:A10,">"&C11)

 

[Shoey68]

Wow! How quick was that?!?!

Thanks alot guys - Worked a dream!