How do I copy a formula with the cell increasing by increments

  • Thread starter Thread starter dgb82
  • Start date Start date
D

dgb82

In regards to what Jaxboo wrote below:

To start RagDyer, you were correct on Jaxboo question, but now I have more
difficult problem.

I would like to take a simple Sum formula such as Sum(b1:e6) and copy it
into
the next cell in an increment so the next cell (below) will read
sum(b7:e12)

How would you answer the above?
 
Assuming you are starting in row 1;

1 sum(b1:e6)
2 sum(b7:e12)

can be created easily by using indirect, and calculating the row numbers
based on current row number, e.g.

=indirect("sum(b" & ((row(a1)-1)*6)+1 & ":e" & (row(a1)*6)& ")"
entered into row a, so when you drag it down it should update a1 to a2 to a3
etc.

aircode, but I believe that's it. If not, you may want to post followup
questions to microsoft.public.excel.worksheet.functions

HTH,
Keith
 
Back
Top