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!

Week Number Year to Year
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
Issues with IF formula
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…