Parent child sum formula help

LinMyers

I need some assistance with a formula. The requirements are:

if a row is a parent, then sum the values of its child rows in column A

If the row is a child, ""

if the row is not a parent AND is not a child, then return the value in column A for that row.

I have tried numerous permutations, some of which get close, but none that work.

Find more posts tagged with

Accepted answers

All comments

Samuel Mueller

I believe you will need a helper column, called "children" or whatever you want.

in that column you will have a column formula, =count(children()), and you will use those results to determine if you are in a child row or a parent row

Corey W.

I think this is does what you are looking for where cost represents your column A:

=IF(COUNT(CHILDREN(cost@row)) > 0, SUM(CHILDREN(cost@row)), IF(COUNT(PARENT(cost@row)) > 0, "", cost@row))

Your scenario doesn't mention what to do with the value in column A on the parent row when there are children. Is it to be included in the SUM as well?

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.