Count children but only some of them

Phil Wightman

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?

Paul Newcome

You would use a COUNTIFS instead.

COUNTIFS(CHILDREN(), "Open")

Paul Newcome

You would use a COUNTIFS instead.

COUNTIFS(CHILDREN(), "Open")