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

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