Help with alternative formula to SUM(CHILDREN) for budgets
I've created a budget template that uses the standard SUM(CHILDREN) formula to add the individual dollar amounts for a specific portion of the budget and obviously gives me a total SUM above the individual dollar amounts (purple cell on left). The intended recipient wants to see the total SUM below the individual lines, not above (purple cell on right). I realize using the CHILDREN formula makes my life much easier, but my customer wants something different.
Can someone quickly help me with a formula to SUM the individual dollar amounts? One of my concerns is that we will constantly be adding lines to the budget, so I need an approach that is flexible and ideally does not rely on any helper column tricks. Thanks!!
Answers
-
Hello,
Based on what I gather from your screen shot something like this may work:
1-Manually create a new row under the last row of your parent for "Services Total"
2-Use a SUMIFS Formula to capture the sum by Column Category:
=SUMIFS([Amount]:[Amount], [Column Category]:[Column Category], "Services")
https://www.linkedin.com/in/zchrispalmer/
-
Thank you Chris! I am going to try this and see if it works for what I want to accomplish - it looks like it will. Appreciate it big time!
-
Great! Thanks for the feedback.
https://www.linkedin.com/in/zchrispalmer/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!