Count Raised flags under child and grandchildren
I am trying to wrap my head around this one and I'm sure others have too.
I want to count all the Flags that are raised under a grandfather (Administration) : the children and their grandchildren.
Currently my solution works, but it's weak. It depends on a fixed range, and as time goes on, new grandchildren and children are added. If the formula's range is not updated, important flags can go unreported.
Here's the formula:
=COUNTIF(Flag3:Flag27, 1) + " Flag(s) raised"
If I could somehow make this work by including the COUNT(CHILDREN()) formula it'd be nice but I can't wrap my head around it. Any feedback would be appreciated.