=countif(e5:e150,">b151")

Hi

I can't seem to get this formula to work...... =COUNTIF(E5:E150,">B151")

B151 is itself a formula working out the average of a list of numbers so I want my formula to work out how many of that list are over the average but it just returns 0 when the current answer should be 3.
The average is 9.6 so if I make my formula =COUNTIF(E5:E150,">9.6") this returns the answer of 3 which is correct, but as the average will change weekly I don't want to have to keep adjusting the formula each week.

Thanks in advance!

That's brilliant thank you. It's been annoying me all night!!