Dragging range (array)

  • Thread starter Thread starter Rita Palazzi
  • Start date Start date
R

Rita Palazzi

How do I copy down a formula where the cell references will increment by
the same amount? E.g. Sum(B100:B104) will increment to Sum(B105:B109)
as opposed to Sum(B101:B105).

Thanks for any help you can provide...

Rita
 
Assuming your summation is starting in row 2 of a column and first summation
is B100:B104 then try:-

=SUM(OFFSET($B$100,(ROW()-2)*5,,5))

If it any other row, change the 2 in the formula above to the row number of
the first cell containing the formula e.g. if you start in row 4 then:

=SUM(OFFSET($B$100,(ROW()-4)*5,,5))

HTH
 

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

QP formulas not working in Excel 2
Increment value in a Formula 7
Dragging formula 8
cell reference in another workbook 3
Increment column on drag down 5
Relative reference autofill increment other than +1 3
Formula based on one cell, pased in another range 1
Efficient Array Formula Construction 8

Back
Top