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)