Countif with Named Range

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

=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.

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif and values greater than zero for a named range	Angela	Microsoft Excel Worksheet Functions	1	17th Nov 2009 04:32 PM
can't use function 'countif' in named range	Roland	Microsoft Excel Misc	8	5th Nov 2008 08:29 PM
can't use function 'countif' in named range	Roland	Microsoft Excel Worksheet Functions	3	4th Nov 2008 12:13 PM
Countif using a named range	Luc	Microsoft Excel Programming	4	28th Feb 2007 11:26 PM
Countif + Named range	=?Utf-8?B?Sm9uYXRoYW4=?=	Microsoft Excel Worksheet Functions	5	16th Aug 2006 09:51 AM