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