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
=SUMIFS(CHILDREN(AMOUNT@row), CHILDREN(STATUS@row), AND(@cell <> "PAID", @cell <> "VOID", @cell <> "OTHER DEPARTMENT"))
Thank you for all of your assistance with this.😅
Help Article Resources
Check out the Formula Handbook template!