Oct 14 2019 08:13 AM
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.
Oct 14 2019 08:21 AM
Oct 14 2019 08:44 AM
@Twifoo, here's an excerpt, showing the formulas for a few selected weeks.
C | D | E | F | G | H | |
14 | Week # | 201845 | =D14+1 | =E14+1 | =F14+1 | =G14+1 |
15 | Product Category 1 Sales | =SUM(MG372:MM372) | =SUM(MN372:MT372) | =SUM(MU372:NA372) | =SUM(NB372:NH372) | =SUM(NI372:NO372) |
16 | Product Category 2 Sales | =SUM(MG373:MM373) | =SUM(MN373:MT373) | =SUM(MU373:NA373) | =SUM(NB373:NH373) | =SUM(NI373:NO373) |
17 | Product Category 3 Sales | =SUM(MG374:MM374) | =SUM(MN374:MT374) | =SUM(MU374:NA374) | =SUM(NB374:NH374) | =SUM(NI374:NO374) |
Oct 14 2019 08:55 AM
Oct 14 2019 09:14 AM