I have a table that shows various interest rates ranges, which is linked to a
data sheet.

5.25% to 5.52%
5.53% to 5.77%
5.78% to 6.02%

I want excel to count for me the number of loans that fall in between thee
5.25% to 5.52% range, etc. The problem is the 5.52% figure is not static. I
am currently using this formula: countif(combined$A1:A200,"<=5.52%"). I
like to avoid having to change the "5.52%" number in the formula everytime my
range changes.