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

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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.