Sum Children If other cells are Checked

craigwaco

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å

Hi Craig,

Try this.

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

Please see the attached link/screenshot for more information.

Sum children if checkbox is checked

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

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å

Great!

Happy to help!