Forum Discussion
sum of 7 cells on one sheet in a column on another sheet
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 Replies
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.
=SUMPRODUCT((ISOWEEKNUM($B$3:$B$27)=F3)*$C$3:$C$27)Is this similar to what you are looking for?
