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
Check out the Formula Handbook template!