Excellent Domenic!
But just copying the respective formulae to A10 and B10, then marking both
cells and dragging the fill handle on B10 across the page achieves the
desired result.
Then mark the range of row 10 and copy down.

I don't see how the OP can achieve his 52 weeks going across the page though
as he would obviously need 367 columns.

Regards

Roger Govier


Domenic wrote:
Assuming that your starting points for Week 1, Daily and Sunday, are A10
and B10, try the following...

For Week 1, Daily...

A10, copied down:

=SUM(OFFSET($B3,,(COLUMN(A10)-COLUMN($A10)+2)/2*7-7,,6))

For Week 1, Sunday...

B10, copied down:

=SUM(OFFSET($B3,,(COLUMN(B10)-COLUMN($B10)+2)/2*7-1))

Then for other weeks, copy A10 to Columns C, E, G, etc., and B10 to
Columns D, F, H, etc. Adjust the references accordingly.

Hope this helps!

In article et,
Robert Moore wrote:


This would be an example of Week 1, The next seven columns would be
Week 2.


Mon Tue Wed Thu Fri Sat Sun
SAM 1 2 3 4 5 6 7
BUTCH 2 3 4 5 6 7 8
ELMER 3 4 5 6 7 8 9

My report for containing each week would look like this:

WEEK 1 WEEK 2
DAILY SUNDAY DAILY SUNDAY
21 7
27 8
33 9

I would like to create the above report, and fill in the formula for all
52 weeks so that as each week is populated I will create the above
report. Assume the cell "SAM" is A3. Your formulas may work fine but
it's not clear to me how to utilize them to create what I need. In
other words, a formula that looks at Mon-Sat of Week 1, then Week 2,
then Week 3, Then a second formula that brings in Sunday of Week 1, then
Week 2, etc.