COUNT IF

[Roses8]

Hi,

In a count if formula, I am trying to get a formula which does the following:

Count if in column D is =>0 and =<3

=COUNTIF(D:D,"=>0 AND =<3")

Thanks.

 

[NBVC]

Try

=Sumproduct(--(D2:D1000>=0),--(D2:D1000<=3))

adjust ranges to suit

 

[Krishnakumar]

Hi,

=SUM(COUNTIF(D:D,{">=0",">3"})*{1,-1})

HTH

 

[Roses8]

thats great. Thank you

 

[Peter_SSs]

.. or this perhaps?
=COUNTIF(D:D,">=0")-COUNTIF(D:D,">3")