Sum decedents

I am seeking help to Sum the total # at the parent level of all children under the secondary parent. Total should appear in the Pandora row which would be the total of Pandora July Offer + Pandora August Offer + Pandora Labor Day Offer. Total should be 12, but my existing formula is counting # of descendants instead of summing each total at the parent rows.

Current formula:

=COUNT(DESCENDANTS(Deliverable@row)) + COUNTIFS(DESCENDANTS(Deliverable@row), ISBLANK(@cell))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!