SUM of Only Parents in Budget Sheet

10/13/21
Answered - Pending Review

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!

Answers

  • Sameer KarkhanisSameer 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.

Sign In or Register to comment.