I am using Excel 2010.

I need to write a formula that calculates the number of occurrences that meet a criteria that is in a range that is equal to/greater than a number with or without a decimal point and less than a number with or without a decimal point. The source data is all in one column.

For example: The range is =>0.1 and less than 1

I tried the following formulas:
=SUMIF($AG$2:$AG$24,"=0.1-0.9")
=COUNTIF($AG$2:$AG$24,"=0.1-0.9")
=COUNTIF($AG$2:$AG$24,"=1*<2")

Nothing worked and I'm sure it is obvious that I was just trying different things.

I'd appreciate any suggestions.

Thanks,
JazziM