CountIF problem

[jjj]

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

 

[Mangesh Yadav]

For range A1:A10

=COUNTIF($A$1:$A$10,">=-2")+COUNTIF($A$1:$A$10,"<=0")-COUNT($A$1:$A$10)

Mangesh

 

[Roger Govier]

Hi

Try
=COUNTIF($A$1:$A$50,"<=0")-COUNTIF($A$1:$A$50,"<-2")


Regards

Roger Govier