COUNTIF CHILD AND UNRESOLVED

K Munz

I have a sheet where we are tracking comments from various agencies.  Each agency lists their comments as children under a parent row of the agency name.  A separate checkbox column indicates whether the comment is resolved.

I am trying to create a formula to calculate the number of unresolved comments per agency in each parent row - I can't determine if this is a COUNTIF or COUNTIFS function.

Here's what I have at the moment:

=COUNTIF((CHILDREN()), Resolved:Resolved, 1)

Appreciate any feedback!

thanks.

 

Paul Newcome

Give this a try...

 

=COUNTIFS(CHILDREN(Resolved@row), 1)