countif

[Guest]

Hi
I would like to count values in columns between 0 and -4 where do I write
the and part
Thanks
Tina

 

[Bob Phillips]

=Countif(A:A,">=-4")-COUNTIF(A:A,">0")

or

=SUMPRODUCT(--(A1:A100>=-4),--(A1:A100<=0),--(A1:A100<>""))

--

HTH

RP
(remove nothere from the email address if mailing direct)