sumif with children

Ian MacFayden

Hey everyone I am trying to set a formula that I believe should work but keep have an error returned. What I'm trying to achieve is in the box that says #unparseable I want it to sum the numbers below it only if the status column shows Approved. I want this to happen in perpetuity for any children rows that are added below the $400.00 row. I want my team to be able to use this without needing to worry about dragging the formula down. I was trying something like =sumif(children(approval status) @cell = approved

I know that's not complete but just for reference of what I've been trying.

Devin Lee

Hey @Ian MacFayden

Try this

=SUM(COLLECT(CHILDREN(Number@row), CHILDREN([approval status]@row), @cell = "Approved"))

L_123

=sumifs(children(number@row),children([approval status]@row),@cell = "Approved)

No need to add the collect and complicate things.