sum of 7 cells on one sheet in a column on another sheet

[brittingham]

Hi, I have a sheet of daily data in one column on sheet 1 and I am trying to create a weekly data sheet on sheet 2.  Is there a way on sheet 2 (the weekly data sheet) to sum 7 days increments so that I can just click on the cell and copy the fomula down the weekly data column with excel automatically having the equation pull every seven cells for summation?  Right now I am typing the sum equation for every seven cells on the weekly spreadsheet.

[#2]

@brittingham 

=SUMPRODUCT((ISOWEEKNUM($B$3:$B$27)=F3)*$C$3:$C$27)

Is this similar to what you are looking for?

 

[#3]

@brittingham 

I'm taking a guess on the data arrangement...Two ways to do it:

SUMIFS:

=SUMIFS($B$2:$B$22,$A$2:$A$22,">="&G2,$A$2:$A$22,"<"&G3)

PivotTable - group by 7 day intervals. See attached.