Rolling Sumif based on weeknumber.
Hello,
I am trying to program a metic that sums the total based on the previous weeknumber. This should continue automatically populate each week.
I'm thinking it looks something like:
=SUMIFS({plug}, {cut week #}, <=WEEKNUMBER(), {cut week #}, >=WEEKNUMBER(-1))
Thanks so much for your help
Answers
-
Hey @Sarah_lee123
You have a range shown in your formula that indicates weeknumber so I will assume you created a helper column to track weeknumbers? Or does that conversion still need to take place? A screenshot of your data would be helpful. I'll work from your date field
=SUMIFS({plug}, {your date field on source sheet}, WEEKNUMBER(@cell)=WEEKNUMBER(TODAY())-1)
If weeknumber already exist as a column in your sheet the formula becomes:
=SUMIFS({plug}, {Weeknumber column on source sheet}, @cell=WEEKNUMBER(TODAY())-1)
Does either of these work for you?
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!