How to Sum up Children Rows when another Column is Checked?
I have been searching and trying for an answer most of the afternoon now, with no success. I have a budget sheet I am working on that needs to sum up the children Amount rows in a month when a checkbox in the Reflected in Account checkbox is checked.
So far I have been trying this formula:
=SUMIFS(CHILDREN([column name to sum]:[column name to sum]), CHILDREN([checkbox column]:[checkbox column]), 1)
Tried several variations to no success. Anyone know why?
Thanks for any help!
Help Article Resources
Check out the Formula Handbook template!