How do you SUM a Child row with the condition that a separate colunm check box is ticked

Jordan Gouwop

Hi I want my spreadsheet to SUM the child numerical value under the condition that the tickbox in a separate column is ticked, so far I have come up with the formula ="Total Withdrawn: " + SUMIF(Completed:Completed , CHILDREN()) but it doesnt seem to work. Some help plese.

J. Craig Williams

Jordan,

 

You are close,

You need the row # for the parent row.

 

Something like this should work:

 

=SUMIF(CHILDREN(Completed23), 1, CHILDREN(ValueColumn23))

 

for row 23 as the parent.

The ValueColumn is the column containing the numbers to be summed.

 

Hope this helps.

 

Craig