If you want the input cells to shift down 4 rows when you copy your formula
down 4 rows, just change T Valko's
=SUM(OFFSET(B$5,(ROWS(D$5:D5)-1)*7,,7))
to
=SUM(OFFSET(Sheet1!B$2,(ROWS(D$2:D2)-1)*7/4,,7))
--
David Biddulph


"Nick W" wrote in message
...
I should have been a little more specific, sorry. The formula is starting
in
B2 of sheet 2. So I want it to be Sum('sheet1"!B5:B11) when it is copied
down to B6 in Sheet 2, it will give the SUM('sheet1'!B12:B18).

I appologize, my syntax is terrible because I really haven't been in a
position that required me to use Excel for more than standard data entry
purposes. I thought that grouping sums would be pretty straight forward.
So
far from what I have learned just trying to get this to work, I am amazed
at
the things I can do with this program.

"T. Valko" wrote:

Assume you want the results to appear in D5 downwards.

Enter this formula in D5 and copy down as needed:

=SUM(OFFSET(B$5,(ROWS(D$5:D5)-1)*7,,7))