I have created a indirect formula that is fixed on a given column even when a
new column is added. However, i need to have this formula advance one row at
a time when it is copied to the following rows.

=(SUM(INDIRECT("$U$2:$Y$2"))/3)
As i fill the rows below i want the row number to advance: See example below.
=(SUM(INDIRECT("$U$3:$Y$3"))/3)
=(SUM(INDIRECT("$U$4:$Y$4"))/3)
The column will be added to the in the U column. The intended function is
which each new column added the oldest information would advance one column
and not be considered in the calculation.

"Niek Otten" wrote:

Please be more specific.
What is your formula? Whare is it located? Where do you want to add
(insert?) columns? What do you expect the result formula to be? Are you sure
you don't confuse columns and rows in your question?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BEW" wrote in message
...
I have created a indirect formula that is fixed on a given column even when
a
new column is added. However, i need to have this formula advance one row
at
a time when it is copied to the following rows.