Formula(s) for reporting Counts of Children w/ Status

spopres

I have a basic plan. Let's say I have 5 Parents, each with a handful of children.

I know there are many ways to get a report of the data I'm looking for, but I want formulas. I'm looking to get the correct syntax for formulas that would give me counts of the children under the parent, by status.

So:

For Cell A - give me the count of children under parent 1 that are in progress

For Cell B - give me the count of children under parent 1 that are complete

For Cell C - give me the count of children under parent 2 that are in progress

and so on......

Thanks in advance for the feedback!

Paul Newcome

You would need a column that pulls the identifying parent level info onto each of the child rows.

=PARENT([Task Name]@row)

From there you can use your standard COUNTIFS to count the statuses as well as the new helper column being equal to the specific text.

spopres

Thank you Paul, working like a charm.

Paul Newcome

Happy to help. 👍️