#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# sum children

Options
edited 12/09/19

I can not get two parent rows in a column to sum or count as a total. I only get "0".

I have parent row#1 that counts 4 children with ="Files: " + COUNT(CHILDREN()) and I have parent row#2 that counts 3 children with ="Files: " + COUNT(CHILDREN()) . However I am not able to total these two parents rows into a total number. Even though I put ="Total: " + SUM(CHILDREN(Name2, Name17)) , I continue to get answer of "0"

Any help would be appreciated

Tags:

• Employee
Options

Hi Michael, you are getting a 0 because you are trying to sum the child rows which likely contain text values and not numbers (you cannot sum text). Try using this formula:

="Total: " + COUNT(CHILDREN(Name2, Name17))

• Options

Travis,

That worked perfect. Thanks so much!

Mike

• edited 05/06/16
Options

I am trying to add 3 cells in a child row ... the cells contain links to other sheets ... any suggestions - tried this formula ="Total: " + SUM(CHILDREN(Name2, Name17)

• Employee
Options

Hi Lisa,

If your intention is to sum the children of a particular parent row, then you need to reference only that parent row.

If your parent row is row 2 and you want to sum the children in the Name column, try this:

="Total: " + SUM(CHILDREN(Name2)

• edited 01/16/17
Options

Hi All,

Here is my case.. The column : Name | Prices

i've 1 parent and 3 children
Parent for ex : row 2

Children = Row 3-5

Could i get the total price in the row parent? I try =SUM(CHILDREN([Name]2)) and i got 0,

This discussion has been closed.