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.

If that value is in a cell, you could use that in the formula:

=countif(combined$A1:A200,"<="&z99)



Confused wrote:

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.

--

Dave Peterson

what is the &z99 referring to in the formula?

"Dave Peterson" wrote:

If that value is in a cell, you could use that in the formula:

=countif(combined$A1:A200,"<="&z99)



Confused wrote:

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.

--

Dave Peterson

Z99 would be the address of the cell holding the percentage.

Change it to what you need.



Confused wrote:

what is the &z99 referring to in the formula?

"Dave Peterson" wrote:

If that value is in a cell, you could use that in the formula:

=countif(combined$A1:A200,"<="&z99)



Confused wrote:

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.

--

Dave Peterson


--

Dave Peterson