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.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
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!