"Bob Phillips" wrote:

=COUNTIF(A:A,"0")-COUNTIF(A:A,"=.25")

This won't do the trick. It subtracts the count of all values less than
0.25 from the count of all values greater than 0. It's not the same as the
number of all values between 0 and 0.25.

I've tried

=COUNTIF(A:A, AND("0","<0.25))

but that returns 0 since it is evaluating whether a value is "TRUE".