Sum Days into Weeks

T

Toll Jenny

I would like to save myself a whole lot of work please...
I have two spreadsheets, one has all the days of the year across the
columns, and the next has all the week ending dates across the colums.
What I need to do is sum the data in each of the rows below the daily dates
into weekly chunks on the same rows in the Weekly spreadsheet.
I have also added these up into montly chunks, but there was only 12 sums to
do so wasn't too bad. I don't relish having to do 52 of them.
Any assistance would be appreciated.
 
T

T. Valko

If you have *all* the dates for a year across a row then you must be using
Excel 2007. (prior versions only have 256 columns, not enough for a year's
worth of dates)

Try this...

B1:NB1 = dates from 1/1/2010 to 12/31/2010
B2:NB2 = values to sum

I'm assuming you want to sum from Monday to Sunday?

B10:??10 = week ending dates for the year (Sunday dates)

Enter this formula in B11:

=SUM(B2:INDEX(2:2,MATCH(B10,1:1,0)))

Enter this formula in C11:

=SUMIFS(2:2,1:1,">"&B10,1:1,"<="&C10)

Copy across as needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top