View Single Post
  #1   Report Post  
Judy Felfe
 
Posts: n/a
Default counting occurrences in a range

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.