COUNTIF doesnt work!

[jjj]

Hi,

My brain isn't switched on this morning, this may be more straigh
forward than I think...

I'm trying to do a Countif function, which only counts those in th
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 tryin
it!

Many thanks in advance

JJ

 

[Roger Govier]

see answers posted to your question in .misc this morning
Regards

Roger Govier

 

[Ashish Mathur]

Hi,

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

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

Regards,