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


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!