Counting by weeks

Hi all,

Table 1 looks similar to this:

..............................Saturday 1 Jan | Sunday 2 Jan | Monday 3 Jan | Tuesday 4 Jan | Wednesday 5 Jan | Thursday 6 Jan | Friday 7 Jan
Row 1............................1......................1......................1......................3.........................4...........................4.....................1
Row 2............................1......................1......................2......................1.........................7...........................4.....................2
Row 3............................1......................1......................3......................3.........................2...........................4.....................8


The columns run for the entire year!
So i want to break down into weeks in a seperate table.

For example I could do =Sum(B2:H2) for Week 1 and I2:O2 for Week 2
However I need to do this for 52 weeks! How can I automate this?


Thank you!

Are the dates real dates or text? If the former, you can use the WEEKNUM function in your SUMIFS.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Look at SUMIFS or SUMPRODUCT function

=SUMIFS(data,date,">=" week1 start,date,"<=" week1 end date")

Create columns of Start/End dates for each week and reference these in the SUMIFS

ANd/OR post a w/book : see yellow banner at top of page on how to attach a w/book.

See sample w/book which use SUMPRODUCT to SUM for all rows in a given week

=SUMPRODUCT((Sheet1!$B$2:$Q$9)*(Sheet1!$B$1:$Q$1>=Sheet2!$B3)*(Sheet1!$B$1:$Q$1<=Sheet2!$C3))