Summing allocation of each child for a Parent

KathrynEK

We have a project capacity sheet for my team. We have it set up as each person as the parent with their projects as the child rows. I want to sum their total allocation of each child in the parent row. Also rows are often added and removed, is there way to manage that so that there isn't any formula updating. Image attached to better understand what I am looking to solve.

NicoLHC

@KathrynEK yiu can calculate try the formula with DESCENDANTS(): Returns all descendants of the current row (including child rows and deeper levels). if you can not succeed tell me .

KathrynEK

Thanks. I think I was overcomplicating it. I was able to figure out what I needed

=SUMIFS([Allocation %]:[Allocation %], [Assigned Resource]:[Assigned Resource], [Team Member]@row)