Thread: Formula to sum based on a change in another column
View Single Post
  #3  
Old May 4th, 2010, 05:09 AM posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
external usenet poster
  
Posts: 1,113
Default Formula to sum based on a change in another column
Excel 2007 PivotTable
Compensated for shifts
overlapping week boundaries.
http://c0718892.cdn.cloudfiles.racks.../05_03_10.xlsx
Pdf preview:
http://www.mediafire.com/file/kjiyajwmdaw/05_03_10.pdf