how can i use the value in one cell in a formula in another cell

[bobw13205]

I want to sum columns by using values that I enter in other cells.
I have a column of numbers but the number of rows will vary depending on the number of enteries. I want to enter a value is one cell, i.e. start row, and a value in a second cell, i.e. stop row in a sum statement.
I want the sum to look like =sum(value in start row:value in stop row) where the start and stop rows will vary depending on the number of rows I want to sum.
each time I want to sum the rows I will enter the start row number, one more that the previous sum formula, and the stop row number. I know that this stop row can be generated by row() since I am entering the number in the row that i want to stop summing at.

example:
I have 25 rows.
I want to sum rows 1 through 7 so i will enter start row as 1 and stop row as 7. the formula would then sum rows 1:7.
the next time I would enter the start row as 8 and and the stop row as 17 so that the formula will sum rows 8 through 17.

 

[Fluff]

Hi & welcome to MrExcel.
How about
=SUM(INDIRECT("A"&D10&":A"&D11))

 

[bobw13205]

Hi & welcome to MrExcel.
How about
=SUM(INDIRECT("A"&D10&":A"&D11))

thanks that worked.

 

[Fluff]

You're welcome