SUMIFS Children Rows when Date is Filled Out
I am trying to do a formula so sum children rows with SUMIFS following this criteria =SUMIFS(CHILDREN([TOTAL OWE - LIVE]:[TOTAL OWE - LIVE]), CHILDREN([MUNIS APPROVAL LEVEL 5 DATE]:[MUNIS APPROVAL LEVEL 5 DATE]), ISDATE(@cell))
In other words, on the parent row named TOTAL PO LIQUIDATED I would like to get the total amount owe-live when the date on the field MUNIS APPROVAL LEVEL 5 DATE is filled out. I would like to copy this formula for all the vendors but when I apply the formula as is now, it's adding all the values in the column, even for different vendors.
Your help is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!