Exclude a child row from parent row with a formula that sums its children
I would like to add a row with formulas under a parent row that calculates the sum of its children. So i need the parent row to skip one of its children that has formulas instead of the content being summed.
is this possible?
In the screenshot you can see when I try to add another row of formulas, i get a circular reference.
Help Article Resources
Check out the Formula Handbook template!