Summary formula to count the number of rows in a sheet that have no children?!

Hi,

I've been racking my brain trying to get this formula to work!

I can create a helper column in the sheet and display the number of children each row has, then simply use a CountIf function - if Children=0, but, I thought i could use a COUNTIF with @cell to not require the helper column?

I have tried the following

=COUNTIF({Ref Col}, COUNT(CHILDREN(@cell))=0)

Thank you

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Hierarchy functions unfortunately cannot use the @cell reference. You will need to use the helper column for that.

sean59916

Thanks for the response Paul. Much appreciated.

Paul Newcome

Happy to help! 👍️

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.