• 469K Members
• 3,555 Online
• 567K Conversations

New Contributor

# 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 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.

4 Replies

# Re: Need to sum groups of 7 columns without manual formula creation

What formulas did you use? If you can attach your sample file, please do.

# Re: Need to sum groups of 7 columns without manual formula creation

@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)

# Re: Need to sum groups of 7 columns without manual formula creation

Under what columns are your first day, last day, and first sum data?

# Re: Need to sum groups of 7 columns without manual formula creation

Perhaps, your formula for week 1 will suffice to help me decipher my suggestion.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies