Count children but only some of them

How should this formula look if I want to only count children that are 'Open'?

="Project stage name - " + COUNT(CHILDREN())

I am using on the parent row in a project risk register so I can collapse stages not reached to focus on the risks for the current stage.

However, some of the risks in the current stage are now closed. This is indicated in a 'Status' column with either open or closed. What changes are required to the formula or teh sheet (yikes) to make the count only of open risks?

Find more posts tagged with

Sheets

Formulas

Project Management

Accepted answers

Paul Newcome

You would use a COUNTIFS instead.

COUNTIFS(CHILDREN(), "Open")

All comments

Paul Newcome

You would use a COUNTIFS instead.

COUNTIFS(CHILDREN(), "Open")

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.