I have a grid sheet broken out by location, Parent Month, and week (for tracking weekly and monthly sales by location).
I'd like to get a summary by week of the multiple locations (ex: Location 1 Week 1 + Location 2 Week 1, etc).
What's the best way to go about collecting this? Screenshot of sheet below (this repeats for all 9 locations Jan-December)
Thank you for any expertise or advice!
Help Article Resources
Check out the Formula Handbook template!