Sum formula for Child cells

Emskie321 ✭✭
edited 09/19/23 in Formulas and Functions

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,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!