Forum Discussion

winetaster99's avatar
winetaster99
Copper Contributor
Oct 14, 2019

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...
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Oct 14, 2019
What formulas did you use? If you can attach your sample file, please do.
  • winetaster99's avatar
    winetaster99
    Copper Contributor
    Oct 14, 2019

    Twifoo, here's an excerpt, showing the formulas for a few selected weeks.

     

     CDEFGH
           
    14Week #201845=D14+1=E14+1=F14+1=G14+1
    15Product 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)
    17Product Category 3 Sales=SUM(MG374:MM374)=SUM(MN374:MT374)=SUM(MU374:NA374)=SUM(NB374:NH374)=SUM(NI374:NO374)
    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Oct 14, 2019
      Perhaps, your formula for week 1 will suffice to help me decipher my suggestion.
    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Oct 14, 2019
      Under what columns are your first day, last day, and first sum data?