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,