Formula Question

[yankeefan70]

Trying to sum a large worksheet but only every 7 rows and want the formula to repeat. Example

A1 to A100 has an # in the cell

Formula I want to repeat in each row in column B
B1 = Sum A1:A7
B2 = Sum A8:A14
etc...

copy and paste only goes to next row B2 now equals A2:A8, etc...

 

[Matty]

Welcome to MrExcel!

In B1, try:

=SUM(INDEX(A$1:A$100,(ROWS(B$1:B1)-1)*7+1):INDEX(A$1:A$100,(ROWS(B$1:B1))*7))

And copy down...

Matty

 

[yankeefan70]

Welcome to MrExcel!

In B1, try:

=SUM(INDEX(A$1:A$100,(ROWS(B$1:B1)-1)*7+1):INDEX(A$1:A$100,(ROWS(B$1:B1))*7))

And copy down...

Matty

Thanks that works.

 

[Matty]

Thanks that works.

Good stuff.

Matty