Welcome!

Sum Children If other cells are Checked

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.

Formulas

Government

Support

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

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))

Great!

Happy to help!

Problems with turning off automatic backups
I am trying to turn off weekly backups, but it's not checked and it shows no history, yet I get backups every week. Is this a bug or there is another place I have to disable it? If it's the right place, why is there no history now?
How to return a blank when searching for max date and one of the dates is blank
I'm searching another sheet date column for the max date where two number columns (CID) are equal. It works fine, but if the list of dates contains a blank, I want the formula to return a blank instead of the max date it finds. =MAX(COLLECT({DAFD}, {CID}, @cell = [CID]@row))
Helper Formula for filtering contradicting Status
I can't quite get the filter to align with my intent. I'm either pulling every status when I want to exclude "Complete" tasks or I can't get parent rows for my project schedule. I want the attached report to do the following for ease of presentation past due AND upcoming activities. Status is one of Not Started or In…