Repeating a seven row sum

[TheLazyUpstart]

Hello!

I have an issue with Excel for Mac and have had to admit defeat - despite it surely having a really simple solution..!

I have an Excel document with multiple sheets - two of which are for daily figures and weekly figures. The sheet for daily figures is filled in manually, with each row corresponding to a day. I need the weekly sheet to add up the daily figures automatically (in blocks of 7 days/rows).

The current formula I'm using looks like this in the first three rows:

=SUM(Daily!C1:C7)
=SUM(Daily!C8:C14)
=SUM(Daily!C15:C21)

But When I select all of these and try to autofill the +7 trend down the column it goes to:

=SUM(Daily!C4:C10)

Instead of:

=SUM(Daily!C22:C38)

Can anyone help?

[NBVC]

Try:

=SUM(INDEX(Daily!$C$1:$C$100,1+((ROW(A1)-1)*7)):INDEX(Daily!$C$1:$C$100,7+((ROW(A1)-1)*7)))

copied down

where C1:C100 is the entire range to sum from.

[TheLazyUpstart]

Thanks for that - I'll give it a blast and let you know how I get on.

Much appreciated :-)

[zbor]

Please make thread solved (go to first post -> edit -> go advanced -> chooose solved from drop down menu)

[TheLazyUpstart]

Thanks for your help on this. Still no joy but we'll get it sorted one way or other.

All the best.