I want to count the number of cells with in a range that fall between a certain range. I can get it to work with one criteria but not when adding the second.
For example, I want to count the number of cells between I8:I24 that are >= 75 but < 90.
This works for greater than 75 but not sure what to do for the less than 90.
=COUNTIF(FIN!$I$8:$I$24,">=.75")
Thank you for any help.
Bookmarks