Thanks for the answer Dave. It is helpful to know why it isn't working, but
I don't think the reference to A1 will work for me.

What I'm really trying to do is create a foolproof SUM formula so that when
a row is inserted, regardless of were, the correct range will be summed.
I've got some people that can barely open Excel, let alone adjust a formula
when they insert a row.

Thanks.

My basic problem.

"DaveB" wrote:

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.