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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLookup and Indirect 3
INDIRECT Syntax 1
Using the INDIRECT function across multiple worksheets 1
Excel Help to copy information from one row at a time to another sheet 1
Formula issues 2
Can INDIRECT hold only the column value constant? 4
Mid column sum formulas with varied ranges to sum 17
Indirect and matching formula isn't working 3

Back
Top