Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to stay fixed on two columns as you add more columns
:) Hello, I have data on column B and C, column E is the output. I will be adding a new column once a week (therefore B becomes C and C ---D) However, i need the output on E to be the result whatever is on B and C...in other words I don't want the formula to 'fix' itself as I add new columns in front of B and C. Thanks! -- usingexcel ------------------------------------------------------------------------ usingexcel's Profile: http://www.excelforum.com/member.php...o&userid=37043 View this thread: http://www.excelforum.com/showthread...hreadid=567702 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to stay fixed on two columns as you add more columns
usingexcel wrote:
:) Hello, I have data on column B and C, column E is the output. I will be adding a new column once a week (therefore B becomes C and C ---D) However, i need the output on E to be the result whatever is on B and C...in other words I don't want the formula to 'fix' itself as I add new columns in front of B and C. Thanks! Hi, You can use the INDIRECT function, so if your formula in column E is the SUM of, for example, B2:C5, you can modify your formula in this way: =SUM(INDIRECT("B2:C5")) So, it doesn't matter how many columns you insert, the formula will always sum the range inside the INDIRECT function. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fixed columns | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I get a formula to use data from a fixed location(NOT vicev | Excel Discussion (Misc queries) | |||
Req Formula to place 1 into next columns | Excel Worksheet Functions |