Increment range reference in formula

Hello All,
I am new here and couldn't find what I am looking for and could be that I am not sure what it is called.

In col A, I have data (hundreds of numbers).
In col B, my formula. i.e =SUM(A7:A13) so sum of 7 cells.

Basically I am summing the data in col A in a group of 7 cells and repeat until the end of the list in col A.

How do I make the formula automatically increments the range references? I dragged the formula cell down to next rows but it doesn't increment corrently.

It should be like this.
=SUM(A7:A13)
=SUM(A14:A20)
=SUM(A21:A27)
=SUM(A28:A34)
and so on....

Thanks in advance for your help.
Paul

Originally Posted by shg

Welcome to the forum.

In B1 and copy down, =SUM(INDEX(A:A, 7 * ROW() - 6): INDEX(A:A, 7 * ROW() ) )

Thanks much shg for the quick response and it works fine.

How can I copy down to have the result next to the end of each group of data? The data is a group of 7 cells down so would be at: B14, B21, B28, and on.

Originally Posted by Paul

If B7 has the formula, =SUM(A7:A13), then:

Select B7:B13. Hover over the lower right corner of B13, then click and drag downward to the bottom of your data. Your sums should line up.

Thank you Paul. That looks simple but effectve.