I have attached an example file similar to the file I am working with, just with sensitive data removed. Each week has multiple columns within it. I need to set a formula that automatically looks at each week before the current week (based on weeknum()-1 to convert from the standard week in Excel to actual ISO week) and sums only the quantities in a specific cell within each week, and I need to set a formula that automatically looks at each week following the current week (and including the current week) that sums only the quantities in a specific cell within those weeks.
Bookmarks