ExcelBanter - countif

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - countif (https://www.excelbanter.com/excel-discussion-misc-queries/11337-countif.html)

tina

countif

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)

"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

All times are GMT +1. The time now is 11:58 PM.