Sum of Children and Cells with Multiple Criterion


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


Thank you for all of your assistance with this.😅


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!