countif

T

tina

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

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