Cumulative sum using SUMIFS
I am trying to calculate a cumulative sum or running total with a sumifs formula. The below is working, but I imagine there is an easier way to do this formula.
Below is the formula I have in Q1 '23 Forecast and I keep adding a new sumifs formula as I go down the row of forecast columns.
=SUMIF($Category$3:$Category$14, $Category@row, $[Actuals (period to date)]$3:$[Actuals (period to date)]$14) + SUMIF($Category$3:$Category$14, $Category@row, [Q1 '23 Forecast]3:[Q1 '23 Forecast]14)
Answers
-
Unfortunately I don't think there's a much faster way to do what you want to do. You could add a helper column with a column formula that sums the Actuals+Qx Forecast for each quarter, then simply SUMIF that column instead. But that seems like potentially more work than just copying and adjusting the formula you already have.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!