Thread: sumifs question
View Single Post
 
Old 10-18-2017, 09:44 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
You could use helper columns for the start and end dates, then refer to them in the SUMIFS formula, or just use a pivot table and group the dates in blocks of 7 days.
Reply With Quote