CELL("address") refers to the cell that last had information entered into it.
For example if you copy CELL("address") into A1, it will initially return
$A$1. But then enter a value in B10 and the original CELL("address") in A1
will now change to $B$10. To stop this you can enter the cell you want to
refer to after the comma, for example:

=CELL("address",A1) will always refer to A1

Does that help?
--
Regards,

DavidB


"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.