Counting # of rows under a parent row that meets a certain criteria

Hi!

I am trying to figure out what formula to use in the below situation:

My sheet has parent rows that determine various phases of a project. Each child row has a status (in progress, complete, etc.) for each step (step 1, step 2, etc.). I am trying to figure out what formula would count how many "in progress" child rows I have under one particular parent row (i.e.) How many steps are completed in phase one - see picture). Thank you!!

Find more posts tagged with

Formulas

Accepted answers

All comments

Leibel S

@JamieH

See below:

=COUNTIFS(CHILDREN(Step@row), @cell <> "", CHILDREN(Status@row), @cell = "In progress")

JamieH

Thank you for this. Unfortunately, it is only counting the two cells being referenced and not all the cells in the children row that meets the criteria. I don't understand the syntax of this formula, so I am not entirely sure where the problem may lie. Can you explain why you have used each piece of this formula so I may be able to adapt it to what I need?

Leibel S

Where did you put the formula?

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.