How do I sum using relative cell positions?
 

I want to set up a formula that calculates a sum based on the data in the 12
columns to the left of the calculation cell. Something like:
SUM(RC[-12]:RC[-1]), *but* if I insert a column to the left, I don't want the
reference to be adjusted to SUM(RC[-13]:RC[-2]).
Probably a simple answer, but I'm stumped.
Thanks,

DavidB,

Try using the INDIRECT worksheet function to "freeze" the columns . . .
something like:

=SUM(INDIRECT("A1:L1"))

----
Regards,
John Mansfield
http://www.pdbook.com


"DavidB" wrote:

I want to set up a formula that calculates a sum based on the data in the 12
columns to the left of the calculation cell. Something like:
SUM(RC[-12]:RC[-1]), *but* if I insert a column to the left, I don't want the
reference to be adjusted to SUM(RC[-13]:RC[-2]).
Probably a simple answer, but I'm stumped.
Thanks,