If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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, |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I turn off relative cell referencing in excel? | Glenn | New Users | 1 | April 13th, 2005 03:06 AM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
how to find relative posiition of first and last non-blank cell in a range? | jarahsang | General Discussion | 4 | June 24th, 2004 05:03 PM |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
using cell contents in pathname | Don Guillett | Worksheet Functions | 7 | January 2nd, 2004 02:11 PM |