| 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, |
| 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) | |||
Threaded Mode
