SUMIFs with Children in a specific criteria

Yogin Bhatti

Hi SS Community,

Hope everyone is staying safe in the current way of living.

I'm looking towards you for help with what seems a fairly simple problem. I want to calculate the allocation % of a Project Manager, for projects that are "Current". The Projects are set up as children under the project manager name. Please see the following screen shot for clarity. i've combed through the community feed on similar issues and have tried a few suggestions but none of them have worked so far.

What am I missing?

Paul Newcome

Try something like this...

=SUMIFS(CHILDREN(), CHILDREN(Status@row), "Current")

Paul Newcome

Try something like this...

=SUMIFS(CHILDREN(), CHILDREN(Status@row), "Current")

Yogin Bhatti

Brilliant. Thank you, Paul.

Paul Newcome

Happy to help! 👍️