adding columns to formula

[david]

I have a sheet that has a bunch of columns that have data.
At the end of each column is an average for the
information in each row. What I want to do is to add more
columns. When I add the column I want the formula in the
last column to add in the column that I just added. How
can I do this?
Thanks,

David

 

[Dave Peterson]

Maybe you could just change the formula:

If your formula were in H1 and looked like:
=AVERAGE(A1:G1)
you could rewrite it like this:
=AVERAGE(A1:OFFSET(H1,0,-1))

Then if you insert a new column H (and shift things to the right one column),
the formula will still point at A1 to the column directly to the left of the
cell with the formula.

David McRitchie also has notes at:
http://www.mvps.org/dmcritchie/excel/offset.htm

You may want to read more about it.