counting occurrences in a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I count the number of occurrences of values between 25,000 and 50,000
within a range of numbers? I have tried

countif(g2:g1695,AND(">=25000","<50000"))

but it gives a result of 0. Thanks in advance.
 
Thanks for the quick response. It worked. I can't say I understand the
formula. Could you break it down for me?

g2:g1695>=25000 is one array, but what does it mean?
what do the double minus signs mean?
Thanks in advance, again!
 
Back
Top