Sumifs and Children


I am trying to sum the values of child row if three conditions in adjacent columns are met, from another sheet and post it on my main sheet.  I reference a parent row and need to sum the children values if they meet the three conditions .  

Specifically, I use a cell value from the main sheet to find the referenced parent row in the other sheet and then sum the POINTS column if the values by rows, in next columns meet the following conditions: Type = "story", Status = "closed", and Resolution is either "fixed" or "done".

I have tried the SUMIFS with the CHILDREN() and a VLOOKUP but am getting nowhere.


Screenshot 2018-10-11 17.22.00.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!