Please help ! Thanks

[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

 

[Roger Govier]

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

Roger Govier

 

[Ninja Stevie]

use an array...

enter the formula

=COUNT(IF(IF($A$1:$A$50>-2,$A$1:$A$50,"")<0,$A$1:$A$50,""))

and instead of pressing enter, press ctrl, shift & enter at the same
time - this will surround the formula with the brackets {} and should
then work.

 

[Bernhard]

Hello

Please Try This
using the formula
=COUNT(IF(($A$1:$A$50>=-2)*($A$1:$A$50<=0),$A$1:$A$50)) and pressing
CTRL+SHIFT+ENTER.

Thank's

 

[Ron Rosenfeld]

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

=COUNTIF(rng,">-2") - COUNTIF(rng,">=0")

("between" is interpreted as exclusive of the bounds; if it is inclusive then
the comparison operators should be ">=-2" and ">0")


--ron