SUMIFs with Children in a specific criteria
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?
Help Article Resources
Check out the Formula Handbook template!