Forum Discussion
Need to sum groups of 7 columns without manual formula creation
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 5...
What formulas did you use? If you can attach your sample file, please do.
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) |