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'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.