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:
1Manually create a new row under the last row of your parent for "Services Total"
2Use a SUMIFS Formula to capture the sum by Column Category:
=SUMIFS([Amount]:[Amount], [Column Category]:[Column Category], "Services")

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.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!