Countif

[umzsexythang]

Hi,
I have the following data:

20
-20
5
-4

I want to count the number of instances in the above range where the value is either less than -15 or greater than +15. (so the result should be 2.

Thanks in advance!

 

[MarkAndrews]

=COUNTIF(A:A,"<15") Less

=COUNTIF(A:A,">=15") More

Adapt to suit

 

[umzsexythang]

Thanks - didn't think of the easiest thing!

 

[SteveO59L]

=COUNTIF(I12:I15,">15")+COUNTIF(I12:I15,"<-15")

 

[Krishnakumar]

=SUM(COUNTIF(A1:A10,{">15","<-15"}))

HTH

 

[Peter_SSs]

.. or possibly this?
=SUMPRODUCT(--(ABS(A1:A10)>15))