indirect formula that will fill down

  • Thread starter Thread starter BEW
  • Start date Start date
B

BEW

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.
 
Back
Top