Trying to sum range of children based on checkboxes
Hi everyone! Hope someone can help.
I am trying to total children in a parent row based on the checkboxes @ row.
Been at this for hours and have tried many different things, the last was "=SUMIFS(CHILDREN([Number of Affected Meters]3:[Number of Affected Meters]4, CHILDREN([Sales or MTS Notified Customer]3:[Sales or MTS Notified Customer]4,1))"
Any help would be much appreciated. Thank you...
Help Article Resources
Check out the Formula Handbook template!