COUNTIF doesnt work!
 

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

see answers posted to your question in .misc this morning
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

Hi,

Try this. Array enter the formula (Ctrl+Shift+Enter)

=count(if((range-2)*(range<0),1,0))

Regards,

"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


--
jjj
------------------------------------------------------------------------
jjj's Profile: http://www.excelforum.com/member.php...fo&userid=7424
View this thread: http://www.excelforum.com/showthread...hreadid=471692