sum the count of Children to a parent row

I have 4 PM's and I want to see the # of jobs they are assigned with the parent row showing the total # of Jobs of all PM's. I have no problem with the count formula for each PM, but I can't figure out the formula for the parent row.


For example

Parent Row: Total: 16 - what is the formula that would give me the Total of 16?

Child rows:

Gregg(7) ="Gregg(" + COUNT(CHILDREN()) + ")"

Sam(1) ="Sam(" + COUNT(CHILDREN()) + ")"

HIllary(3) ="HIllary(" + COUNT(CHILDREN()) + ")"

TBD(5) ="TBD(" + COUNT(CHILDREN()) + ")"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!