Sum individual dated cells into corresponding weeks

[kamelkid2]

refer to attached spreadsheet for my (unefficient) solution to the problem i have at hand where i want to sum the data into weekly totals based off of their assigned day #.

sumif week example(2).xlsx

i have gotten it to work but when the spreadsheet gets large, the processing time bogs down on slower computers and it just looks like plain garbage.

here is the code i used to sum the first seven days in to week 1

=SUMIF(B:B,B2*7-0,D:D)+SUMIF(B:B,B2*7-1,D:D)+SUMIF(B:B,B2*7-2,D:D)+SUMIF(B:B,B2*7-3,D:D)+SUMIF(B:B,B2*7-4,D:D)+SUMIF(B:B,B2*7-5,D:D)+SUMIF(B:B,B2*7-6,D:D)

day 1 is in cell b2, so i have it to sumif based on each particular day as a separate statement and then just add them all up. is there a more elegant solution i could use?

i am using excel 2007 but will also be putting this in google spreadsheets if that matters

thank you for at least looking into it - you all have been so very helpful to me as it stands - i am very appreciative

[NBVC]

Not sure about more efficient... .SUMIF is already very efficient.. but here is another way:

=SUM(SUMIF(B:B,B2*7-{0,1,2,3,4,5,6},D:D))

I am not sure if that would work in GoogleDocs though.

[kamelkid2]

yeah it is only reading day 7 with that formula in docs but at least now i have something better to go off of for future excel only projects. thank you again

[kamelkid2]

=arrayformula(SUM(SUMIF(B:B,B2*7-{0,1,2,3,4,5,6},d:d)))

worked in google docs. thank you for help me coding is so much cleaner now

[NBVC]

Thank you for that update...