Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) |