Function for Counting Children of Parent Rows

Hi - I have been wrestling with this function and need some help.

Here is the data:

In my sheet summary, I am trying to enter a function to count the children who answer yes. I have tried it a bunch of ways, and it will count if I only ask it to count children, or if I only ask it to count the yes answers, but I cannot get them together.

=COUNTIF(CHILDREN([Month/Year - MRN]1, [Documented Flush q12?]:[Documented Flush q12?],"Y"))

Thoughts? Thanks!

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @EB_RN

To use the Children function, here's the formula

=COUNTIFS(CHILDREN([Documented Flush q12?]1), "y")

From the snippet, it appears only children have Y/N responses and I can only see one parent, which made me wonder if the Children criteria was necessary

=COUNTIFS([Documented Flush q12?]:[Documented Flush q12?], "y")

cheers

Kelly

Kelly Moore

Hey @EB_RN

As an alternative, you could also bring in your date column to help you filter by month. In my sheets I try very hard not to force myself to manually choose a specific row- I prefer formulas to choose data for me.

=COUNTIFS([Documented Flush q12?]:[Documented Flush q12?], "y", Date:Date, MONTH(@cell)=12)

I hope you have joyful holidays as well

Kelly

All comments

Kelly Moore

Hey @EB_RN

To use the Children function, here's the formula

=COUNTIFS(CHILDREN([Documented Flush q12?]1), "y")

From the snippet, it appears only children have Y/N responses and I can only see one parent, which made me wonder if the Children criteria was necessary

=COUNTIFS([Documented Flush q12?]:[Documented Flush q12?], "y")

cheers

Kelly

EB_RN

@Kelly Moore It is a monthly audit, which is why I want the parent row for future months. But this worked perfectly, and I tried it out for the next month and it worked for the new group of data. thank you so much!! happy holidays!

Kelly Moore

Hey @EB_RN

=COUNTIFS([Documented Flush q12?]:[Documented Flush q12?], "y", Date:Date, MONTH(@cell)=12)

I hope you have joyful holidays as well

Kelly

EB_RN

oh my gosh that one is even better - you are so right, that is awesome. thank you again for 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.