| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif with Named Range
I have a Named Range on a hidden sheet where the data may change. I am
trying to write a formula on another sheet which will Count the values that are greater than the Named Range value. Ex: Countif(Defects!$E:$E,Overage).... with or without quotes has been tried. I have tried several variations but it will not work. There is only one value in my named range so, the Named Range of Overage is .001. Any thoughts on how to make this work. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Countif with Named Range
Have you tried the following.
=Countif(Defects!$E:$E,"" & Overage) "D" wrote: I have a Named Range on a hidden sheet where the data may change. I am trying to write a formula on another sheet which will Count the values that are greater than the Named Range value. Ex: Countif(Defects!$E:$E,Overage).... with or without quotes has been tried. I have tried several variations but it will not work. There is only one value in my named range so, the Named Range of Overage is .001. Any thoughts on how to make this work. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Countif with Named Range
=COUNTIF(E:E,""&Overage)
"D" wrote: I have a Named Range on a hidden sheet where the data may change. I am trying to write a formula on another sheet which will Count the values that are greater than the Named Range value. Ex: Countif(Defects!$E:$E,Overage).... with or without quotes has been tried. I have tried several variations but it will not work. There is only one value in my named range so, the Named Range of Overage is .001. Any thoughts on how to make this work. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Countif with Named Range
Perfect!!! I knew it had to be something simple. Works like a charm!!
"Barb Reinhardt" wrote: Have you tried the following. =Countif(Defects!$E:$E,"" & Overage) "D" wrote: I have a Named Range on a hidden sheet where the data may change. I am trying to write a formula on another sheet which will Count the values that are greater than the Named Range value. Ex: Countif(Defects!$E:$E,Overage).... with or without quotes has been tried. I have tried several variations but it will not work. There is only one value in my named range so, the Named Range of Overage is .001. Any thoughts on how to make this work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif and values greater than zero for a named range | Excel Worksheet Functions | |||
| can't use function 'countif' in named range | Excel Discussion (Misc queries) | |||
| can't use function 'countif' in named range | Excel Worksheet Functions | |||
| Countif using a named range | Excel Programming | |||
| Countif + Named range | Excel Worksheet Functions | |||
Linear Mode
