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...
=SUMPRODUCT((ISOWEEKNUM($B$3:$B$27)=F3)*$C$3:$C$27)Is this similar to what you are looking for?