Formula to count/sum grandchildren

D Morgan

Is there a formula that can be used to count or sum the grandchildren of a parent row?

For Instance: 

• Parent Row: United States
•    Child Row: East
•       Grandchild: Florida
•       Grandchild: Georgia
•    Child Row: West
•       Grandchild: California
•       Grandchild: Oregon
•    Child Row: Central
•       Grandchild: Illinois
•       Grandchild: Texas
•       Grandchild: Oklahoma

Count the states for the US Region

Ajay Jindal

For your example, use the formula =COUNT(CHILDREN()) on the child rows that will count the grand children and use =SUM(CHILDREN()) on the parent row to add up the totals for all the child rows.

 

One thing to note is that COUNT(CHILDREN()) will only count the child row if there is content in the cell in that column (it ignores blank cells).  You can use COUNT(CHILDREN([primary column]x) - so it will effectively be looking at a different columns (the primary column is a good choice).