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
Bookmarks