Auto-filling formulas etc

[Neil G]

Why is it that if I use the drag cell method to auto-fill formulas, it won't
recognise increments of more than 1
For example.

I create two consecutive sum cells thus
Cell F15 has =sum(B1515)
Cell F16 has =sum(B2020)

I want to select those two cells and drag down, so that the sum in each row
increments by 5.
IE F17 would become =sum(B2525) and so on.

Is there a logical reason that I can't do this

Thanks
Neil

 

[Frank Kabel]

Hi
enter the following formula in F15:
=SUM(OFFSET($B$15:$D$15,(ROW(1:1)-1)*5,0))
and copy this down

 

[Neil G]

Thanks Frank
Just what I need.
Neil

Hi
enter the following formula in F15:
=SUM(OFFSET($B$15:$D$15,(ROW(1:1)-1)*5,0))
and copy this down