Sum Children based on active

Manish Govindji

I am trying to calculate children in COS USD, for all Active Status.

Thank you.

Paul Newcome

Try something like this...

=SUMIFS(CHILDREN(), CHILDREN(Status@row), @cell = "Active")

Paul Newcome

Try something like this...

=SUMIFS(CHILDREN(), CHILDREN(Status@row), @cell = "Active")

Manish Govindji

Thank you @Paul Newcome I spent almost half a day trying various formulas, googled but nothing seemed to work. this one worked as soon as i hit enter! I was mixing cell and row.

Thank you so much, have a wonderful day.

Paul Newcome

Happy to help. 👍️