count how many between two values

[Jeremy H]

I am trying to count the number of entries in a column that are BETWEEN -20
and 20. Everything I have tried returns a zero or a wrong value because it
is counting everything ( such as -50 is less than 20 so it counts it, and 50
is more than -20 so it counts it) Any ideas?

 

[Frank Kabel]

Hi
one way:
=COUNTIF(A:A,">10")-COUNTIF(A:A,">=20")
counts everything between 10 and 20

or use
=SUMPRODUCT(--(A1:A100>10),--(A1:A100<20))

 

[Jeremy H]

Thank you very much,
That countif formula worked perfectly, and I really appreciate it.