Formula - Adding count of parent and children rows

Hi!

I am trying to add the sum of the parent row that has "2024 in the years active + the children row that has "2024".

The current formula only counts children, but would like to add the parent row's active year too: =COUNTIFS(CHILDREN([AM/PM Years Active]@row), HAS(@cell, "2024"))

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for context?

KasandraC

Thank you! Please see here - I am trying to add the subrows of BeeKeeperAI plus the main row that are active so if the subrow was active the highlighted cell should show 2 instead, since its not active in 2024, it shows 0 but I'm trying to get it to show 1 to count the main Beekeeper row as well.

Paul Newcome

Try this:

=IFERROR(COUNTIFS(CHILDREN([Years Active]@row), HAS(@cell, "2024")), 0) + IF(HAS([Years Active]@row, "2024"), 1, 0)

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.