Count/sum only if one of children is a specific value and scope

Hello everyone,

I was wondering if someone can help - I would like to do some financial departmental metrics in terms of revenue. Now, I have a sheet with about 300 different projects and would like to create another sheet where I will only see the sum of the revenue/totals for each of the 3 columns (as below). My costs are always in the parent row, however, not all parent rows have children with scope. As shown below, I'd only like to count the costs if the child row contains a certain value (e.g. Jane Green) and scope. Is there a formula for this I could use?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!