Sum of Children and Cells with Multiple Criterion

Options

I am trying to Sum up all of the children cells and one row cells that do not include the following "Status" category.

I thought the following formula (that has been a lifesaver) would add them up since it is the same criteria but I'm not even clear what it's adding up.

The value based on the cells should be = $60,877.98 this is the sum of the parent rows+individual rows with no children

=SUMIFS(CHILDREN(AMOUNT@row), CHILDREN(STATUS@row), AND(@cell <> "PAID", @cell <> "VOID", @cell <> "OTHER DEPARTMENT"))

Thank you for all of your assistance with this.😅

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!