Sumif across Children and Grand Children
I am trying to SUMIF accross all Children and Grand Children but unfortunately retrieving an #UNPARSEABLE value.
Here are the formulas I have been trying:
SUMIF($[Payment Status]5:$[Payment Status]50), "Received", [2019 Wk 02]5:[2019 Wk 02]50))
=> result to #UNPARSEABLE
SUMIF(CHILDREN($[Payment Status]27), "Received", CHILDREN([2019 Wk 01]27)
=> result will not sum the grand children but only the children, which is not what I am looking for.
Is there a possibility to sumif across the whole column regardless Parent / Children / Grand Children ?
Thx a lot for the help
Help Article Resources
Check out the Formula Handbook template!