Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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...... |
#2
|
|||
|
|||
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...... |
#3
|
|||
|
|||
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...... |
#4
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
countif argument for 3 occurences of which 1 refers to a range | Excel Discussion (Misc queries) | |||
How do I set up an argument which asks for multiple criteria | Excel Discussion (Misc queries) | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |