Sum Children If other cells are Checked

craigwaco · 10/11/18

Hello Community,

I'm trying to get a sum of children cells if a checkbox in another column is checked.

For instance, if Column A has row 1 checked, I want the Column 10 row 1 counted as part of the sum.

Andrée Starå · 10/12/18

Hi Craig,

Try this.

Formula: =SUMIF(CHILDREN(If@row); 1; CHILDREN([Total Test]@row))

Please see the attached link/screenshot for more information.

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

craigwaco · 10/15/18

Andree,

Thank you so much. This worked wonderfully!

This is the formula that worked for me.

=SUMIF(CHILDREN(If@row), 1, CHILDREN([total test]@row))

Andrée Starå · 10/15/18

Great!

Happy to help!

Comments