Yes, it's been a long year. We're all getting tired! :-)
--
David Biddulph

T. Valko wrote:
Well duh!

Disregard that previous post. It's dinner time!


"T. Valko" wrote in message
...
Works for me (Excel 2002). I get:

B2: =SUM(Sheet1!B5:B11)
B6: =SUM(Sheet1!B12:B18)
B10: =SUM(Sheet1!B13:B19)
B14: =SUM(Sheet1!B20:B26)
B18: =SUM(Sheet1!B21:B27)

And all cells in-between are empty.

--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Didn't work for me.
B10 shows =SUM(Sheet1!B13:B19)
B14 shows =SUM(Sheet1!B20:B26)
B18 shows =SUM(Sheet1!B21:B27)
so alternately stepping 1 row & 7 rows.
I think your original OFFSET formula was the right way, modified
for the OP's changed requirements.
--
David Biddulph

"T. Valko" wrote in message
...
Enter this formula in B2:

=SUM(Sheet1!B5:B11)

Enter this formula in B6:

=SUM(Sheet1!B12:B18)

Select the range B2:B9 and drag copy down as needed.

--
Biff
Microsoft Excel MVP


"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))