| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using COUNTIF to find numbers within a range greater than the mean
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 (whe COUNTIF(range,=H2223) instead of typing in the mean (whe COUNTIF(range,=1.105432789etc). I have to do this for several ranges. Anyway to get the formula to take the calculated value? |
|
#2
|
|||
|
|||
|
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 "Lowkey" wrote: 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 (whe COUNTIF(range,=H2223) instead of typing in the mean (whe COUNTIF(range,=1.105432789etc). I have to do this for several ranges. Anyway to get the formula to take the calculated value? |
|
#3
|
|||
|
|||
|
Works great. Could you tell me what formula to use to find and then count all
recurring values within a range? "Peo Sjoblom" wrote: 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 "Lowkey" wrote: 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 (whe COUNTIF(range,=H2223) instead of typing in the mean (whe COUNTIF(range,=1.105432789etc). I have to do this for several ranges. Anyway to get the formula to take the calculated value? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find cell contents in range | Excel Discussion (Misc queries) | |||
| Match numbers in range | Excel Discussion (Misc queries) | |||
| Ploting data with a large range including negative numbers | Charts and Charting in Excel | |||
| find numbers in a range that add to a specific value | Excel Discussion (Misc queries) | |||
| two columns of numbers, need to sort/filter to find one number th. | Excel Discussion (Misc queries) | |||
Linear Mode
