SUMIFS Children Rows when Date is Filled Out
Great Morning!
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.
Thank you!
Answers
-
This seems to be the same topic as:
So to make it short:
=SUMIFS(CHILDREN(), CHILDREN([MUNIS APPROVAL LEVEL 5 DATE]@row), ISDATE(@cell))
Hope it helped!
-
Hello David,
Thank you for your response. Your formula works perfectly for the column Total Owe-Live that adds up the children of the same column; however, the Total PO Liquidated is referring to the children rows at Total Owe-Live (different column). How should we formulate that function? (screenshot attached)
The parent Row Total Owe-Live has the following formula (when the date is blank): =SUMIFS(CHILDREN(), CHILDREN([MUNIS APPROVAL LEVEL 5 DATE]@row), ISBLANK(@cell))
Thank you in advance for your help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!