Adding only children rows that have check box

Tara Day Ulrich

Hi Everyone,

I'm developing a sheet to track mileage on person vehicles. I have a parent row that totals the number of miles per month, and the children rows show each individual trip. I have a check box at the right to show when a trip has received approval from a supervisor. My question is: how do I get the formula in the parent row to total only those children rows where the checkbox is checked? I have tried several different formulas, but I keep getting Unparseable. Any help would be appreciated!

Thank you!

Paul Newcome

You don't need a helper column for this. You could just use a SUMIFS.

=SUMIFS(CHILDREN(), CHILDREN([Checkbox Column]@row), 1)

John Jonassen

Probably add in a helper column next to the check box of the children row and include a formula of =if([SupervisorApprovalCheckBox]=1,[Miles],0)

Then, in the Parent row, do a formula of =Sum(Children()) in that new helper column.

Paul Newcome

You don't need a helper column for this. You could just use a SUMIFS.

=SUMIFS(CHILDREN(), CHILDREN([Checkbox Column]@row), 1)