ExcelBanter - Use value in cell as numeric reference to a row, within a sum func

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Use value in cell as numeric reference to a row, within a sum func (https://www.excelbanter.com/excel-programming/395699-re-use-value-cell-numeric-reference-row-within-sum-func.html)

Jim Thomlinson

Use value in cell as numeric reference to a row, within a sum func

=SUM(INDIRECT("D3:D"&A5))
--
HTH...

Jim Thomlinson

"cspr" wrote:

I would like to be able to use a value in a cell as the numeric reference to
a row in another column, to which to sum values in that column.
Eg.
If A5 = 7, sum values in cells D3 to D7.
If A5 = 13, sum values in cells D3 to D13.

All times are GMT +1. The time now is 05:16 PM.