Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CountIF problem
Hi, My brain isn't switched on this morning, this may be more straight forward than I think... I'm trying to do a Countif function, which only counts those in the range which are between "0" and "-2". Lets say the range is $A$1 : $A$50, and contains values between -3.00 and 5.00. How can i write this countif formula? It doesnt work the way i'm trying it! Many thanks in advance JJJ -- jjj ------------------------------------------------------------------------ jjj's Profile: http://www.excelforum.com/member.php...fo&userid=7424 View this thread: http://www.excelforum.com/showthread...hreadid=471682 |
#2
|
|||
|
|||
For range A1:A10
=COUNTIF($A$1:$A$10,"=-2")+COUNTIF($A$1:$A$10,"<=0")-COUNT($A$1:$A$10) Mangesh "jjj" wrote in message ... Hi, My brain isn't switched on this morning, this may be more straight forward than I think... I'm trying to do a Countif function, which only counts those in the range which are between "0" and "-2". Lets say the range is $A$1 : $A$50, and contains values between -3.00 and 5.00. How can i write this countif formula? It doesnt work the way i'm trying it! Many thanks in advance JJJ -- jjj ------------------------------------------------------------------------ jjj's Profile: http://www.excelforum.com/member.php...fo&userid=7424 View this thread: http://www.excelforum.com/showthread...hreadid=471682 |
#3
|
|||
|
|||
Hi
Try =COUNTIF($A$1:$A$50,"<=0")-COUNTIF($A$1:$A$50,"<-2") Regards Roger Govier jjj wrote: Hi, My brain isn't switched on this morning, this may be more straight forward than I think... I'm trying to do a Countif function, which only counts those in the range which are between "0" and "-2". Lets say the range is $A$1 : $A$50, and contains values between -3.00 and 5.00. How can i write this countif formula? It doesnt work the way i'm trying it! Many thanks in advance JJJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Problem | Excel Discussion (Misc queries) | |||
COUNTIF and automatic type conversion problem | Excel Discussion (Misc queries) | |||
COUNTIF and automatic type conversion problem | Excel Worksheet Functions | |||
countif problem | Excel Discussion (Misc queries) | |||
problem with countif | Excel Worksheet Functions |