Summing up a variable range of cells

I am sure this is not difficult, I ma just struggling with the syntax.

On a worksheet I want to be able to specify two rows as row numbers. rowA and rowB.

Then elsewhere I want to be able to write a formula that sums up the cells in a fixed column on a different sheet between those two rows.

Something like this....

SUM(CELL('Sheet1'ArowA, 'Sheet1'ArowB)

Which is summing up the cells between Row A Column A on Sheet 1 and Row B Column A on Sheet 1.

I think the use of the Cell function to specify the cells would do, but I am struggling with the syntax to include a fixed column in the cell reference and a varaiable (other cell) for the row.

I hope my requirement makes sense, as this would save me a lot of tedious work.


Thanks in anticipation.

(I will keep hacking away, and if I crack it will post the answer here)

Thanks for the reply, but that's not quite what I want. Maybe I wasn't clear.

To take your example..

I want to specify the 2 in A2 in one cell, and the 9 in B9 in a different cell

The idea being that by changing the value in two cells I can change the scope of the range. The reason why this is important is because I will do this sum for different columns in many places and I want to change the row range easily without editing multiple cells.

Thanks Lem, I have just found my own solution (a lot of trial and error). This is my solution

=SUM(INDIRECT("Totals!S"&H2):INDIRECT("Totals!S"&H3))

If H2 = 10 and H3 = 20 then this is equivalent to

SUM('Totals'!S10:'Totals'!S20)

Thanks again