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

L

Lowkey

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?
 
P

Peo Sjoblom

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
 
L

Lowkey

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