Using COUNTIF to find numbers within a range greater than the mean

[Guest]

I have a range of numbers where the mean is 1.105... and I want to count all
the numbers greater than or equal to the mean by using the calulated mean
cell (where: COUNTIF(range,>=H2223) instead of typing in the mean (where:
COUNTIF(range,>=1.105432789etc). I have to do this for several ranges. Anyway
to get the formula to take the calculated value?

 

[Guest]

You need to separate the cell reference from the >= or else it will look for
the text string H2223

COUNTIF(range,">="&H2223)


will work


Regards,

Peo Sjoblom

 

[Guest]

Works great. Could you tell me what formula to use to find and then count all
recurring values within a range?