=Count(children()) of multiple parent rows.

Sarah Zimmerman

I'm trying to count the contents of multiple children in different cells for a grand total. I've organized my information by the media outlet, which will count its children for an "at a glance" total for ease of use. I would like the parent cell ("2 open inquiries") to count all the children for a total of all open inquiries. You can see that right now, it is only counting two instead of three. Is =Count(children()) the right formula for this task? There isn't a "grandchildren" function so I'm unsure of how this could be written.

I'm hopeful better minds than mine can help me figure this out.

(Note: I've scratched out sensitive information for obvious reasons.)

Jason Tarpinian

You could use a SUM(CHILDREN()) for your "grandparent" row, this would then sum up the COUNT(CHILDREN()) from your gray rows.

Sarah Zimmerman

Thank you for your response, Jason. I tried this formula, based on your suggestion but it doesn't seem to be counting anything. I'm not sure if I did it right.

=(SUM(CHILDREN(Topic3:Topic5)) + " open inquiries ")