=SUM(INDEX(B:B,ROW(B1)*6-5):INDEX(B:B,ROW(B1)*6))

Enter in C1 and drag/copy down until you get zeros.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 12:21:01 -0700, Jaxboo
wrote:

I would like to take a simple Sum formula such as Sum(b1:b6) and copy it into
the next cell in an increment so the next cell (below) will read sum(b7:b12)

How would I do this? I have a large number of cells I will be doing this
with and really do not want to have to go back and forth between worksheets
to select the cells.