SUM of Only Parents in Budget Sheet

limcneil

Hello! I've created a budget sheet with sub items. I figured out how to SUM the Children under a Parent line but what is the simplest way to SUM only the Parents for a Total that does not include both Children and Parents? Thank yo!

Sameer Karkhanis

If your budget hierarchy has the top level node as the name of the budget/project then you apply the exact same logic to the column at the top level node. Use the same formula =SUM(CHILDREN()), it will only calculate the SUM of only its immediate children.