I think the problem is in the CELL function. The Help description says that
if you omit the second parameter, it returns the address of the cell last
changed. Can you not just use =SUM(OFFSET(A1,-4,0,4,1)) where you replace A1
with the address of the cell into which you enter this formula?
--

Simon


"Quizarate" wrote:

I'd like to create a non VBA based formula that will sum up a range that is
offset from the activecell. I tried the following formula to sum a four cell
range:

=SUM(OFFSET(INDIRECT(CELL("address")),-4,0,4,1))

This works fine when I initially enter it, but when numbers in the sum range
change the formula result changes to 0.

Anyone have any ideas of how I can get around this?

Thanks.