COUNTIF CHILD AND UNRESOLVED

K MunzK Munz ✭✭✭✭
edited 12/09/19 in Formulas and Functions
12/13/18 Edited 12/09/19

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.

 

Tags:

Comments

Sign In or Register to comment.