=SUM(INDEX(A:A,ROW(A1)*7-6):INDEX(A:A,ROW(A1)*7))


Gord Dibben MS Excel MVP

On Mon, 9 Jun 2008 19:54:25 -0700 (PDT), wrote:

If I have number in every cell A1:A14 and would like to have cell B1
show the sum of the first seven rows (A1:A7), and B2 show the sum of
the next seven (A8:A14), how do I do this automatically? I.E. I have
thousands of rows of data, and would like a formula that I can drag
down, which will sum every 7 rows.

Thanks!