SUMIF using children in a Column

sean.hagan1088

I'm trying to get the Sum of the Yield column but I want it broken down by County name in a Sheet Summary.

This is the formula I tried but its coming back #UNPARSEABLE:

=SUMIF(Children(County:County, ="Lee", Yield:Yield))

Any ideas? Can it even be done that way?

Find more posts tagged with

Accepted answers

All comments

Jeremy C

@sean.hagan1088

Have you tried using =Sum(Children) in the Yield cell of the parent line to get the totals for each County and then run a summary?

sean.hagan1088

@Jeremy C

I did and it works when I have that there, but they aren't wanting the totals on the sheet if at all possible and would like them in the sheet summary.

Jeremy C

@sean.hagan1088

If they don't want to 'see' the numbers there you could change the font color to match the background/fill color. Unfortunately I haven't used the sheet summary functionality so I'm not much help there.

sean.hagan1088

@Jeremy C let me give it a try and see. Appreciate your 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.