sum children

Michael Pierson

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

 

Travis

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))

Michael Pierson

Travis,

 

That worked perfect. Thanks so much!

 

Mike

Lisa Hallowell

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)

Travis

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)

Billy Fadli

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,