Dragging range (array)
 

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

Dragging range (array)
 

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

"Rita Palazzi" wrote:

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