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,