=SUMPRODUCT(--(G2:G1695=25000),--(G2:G1695<50000))


--
HTH

Bob Phillips

"Judy Felfe" wrote in message
...
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.