Help with alternative formula to SUM(CHILDREN) for budgets

annah

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!!

Budget question.png

=Chris Palmer

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")