Help to SUM 5 rows and then SUM the next 5 rows and so on

[sav1979]

Hi all, Probably a simple answer but I cannot fathom it and would really appreciate some help.

I have a list of dates in column A, in column B I have sales figures per day. In column C, I want to put the total sales per week. Could someone help me with a formula so that I can drag the first cell down until all weeks are completed?

Many thanks

[Colin Legg]

Hi,

A nice and simple way to do this would be to use a pivot table. Set the dates as the row labels and then right click on them > Group > Days

You can choose the starting day and group them by 7 days.

[Cutter]

Without seeing a sample - here is a generic suggestion

In cell C5 put this: =SUM(B1:B5)

Now select the range C1:C5

Drag that range down - cell C10 will now have formula: =SUM(B6:B10),
Cell C15 will have =SUM(B1:B16)
etc

[highbarger]

I came up with a formula that works, but ONLY with a helper column. I put the formula

=WEEKNUM(A2,1) in C2

and the formula

=SUMIF(C:C,WEEKNUM(A2,1),B:B) in cell D2.

You could always hide column C...

[sav1979]

Thanks guys. Excellent input. Much appreciated. Will mark as solved.