COUNTIF CHILD AND UNRESOLVED
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:
0
Comments
Give this a try...
=COUNTIFS(CHILDREN([email protected]), 1)
thinkspi.com