countif greater/less than argument

[nme#1]

Hi I'm trying to get a countif argument to work where the condition is greter
than "a reference", ie:

=(COUNTIF(K5:K1136,">DATA_RANGES!C3"))-COUNTIF(K5:K1136,">DATA_RANGES!C4")

I am guessing it is simple, but just can't figure it out......

[Max]

Try:

=COUNTIF(K5:K1136,">"&Data_Ranges!C3)
-COUNTIF(K5:K1136,">"&Data_Ranges!C4)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"nme#1" <nme#[email protected]> wrote in message
news:[email protected]...
> Hi I'm trying to get a countif argument to work where the condition is
greter
> than "a reference", ie:
>
> =(COUNTIF(K5:K1136,">DATA_RANGES!C3"))-COUNTIF(K5:K1136,">DATA_RANGES!C4")
>
> I am guessing it is simple, but just can't figure it out......

[nme#1]

Excellent! Thanks Max, most appreciated!!

"Max" wrote:

> Try:
>
> =COUNTIF(K5:K1136,">"&Data_Ranges!C3)
> -COUNTIF(K5:K1136,">"&Data_Ranges!C4)
>
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
> "nme#1" <nme#[email protected]> wrote in message
> news:[email protected]...
> > Hi I'm trying to get a countif argument to work where the condition is
> greter
> > than "a reference", ie:
> >
> > =(COUNTIF(K5:K1136,">DATA_RANGES!C3"))-COUNTIF(K5:K1136,">DATA_RANGES!C4")
> >
> > I am guessing it is simple, but just can't figure it out......
>
>
>

[Max]

You're welcome !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"nme#1" <[email protected]> wrote in message
news:[email protected]...
> Excellent! Thanks Max, most appreciated!!