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


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