countif greater/less than argument
 

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

countif greater/less than argument
 

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" wrote in message
...
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......

countif greater/less than argument
 

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" wrote in message
...
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......

countif greater/less than argument
 

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