Sum formula for Child cells

Emskie321

Hello Team,

Please let me know the best formular to add up the values for Child cells, if some of the cells are blank or include 0 values. Below is a screenshot.

I need to calculate the total value for each Region for the Stock Count.

Many Thanks,

Andrée Starå

Hi @Emskie321

I hope you're well and safe!

Try this.

=SUM(CHILDREN())

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Nick Korna

Hi @Emskie321,

In the cell you have highlighted and to the stock count cell next to Region B:

=SUM(CHILDREN())

The 0s & blanks won't affect anything - they just are ignored.

If you want the total in another column, you would use:

=SUM(CHILDREN([Stock Count]@row))

Hope this helps, but if you've any problems/questions then just post! 🙂

Emskie321

Thanks @Andrée Starå & @Nick Korna,

The SUM formula works great! Much Appreciated.

Andrée Starå

@Emskie321

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!