sum children

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

Find more posts tagged with

Formulas

Comments

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,