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...
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) |
Perhaps, your formula for week 1 will suffice to help me decipher my suggestion.