I have a very long data set (each column is one day's worth of data), and I need to set up formulas to automatically provide a sum for that data, at the weekly and monthly level.
After creating 52 manual formulas for the weekly data in 2018, I realized that there must be an easier way. Copying the formulas for all 52 weeks (in other words, 52 cells in a row, containing each week's formula) doesn't work, as that doesn't correspond to the right cells in the 2019 daily column set.
This is probably something basic - so no judgments, please!! Any tips would be greatly appreciated.