Counting Parents on a sheet ignorning children.

dwayne.waterman21236 · 04/08/19

Hi everyone, I have a sheet in which I have parents and children. I only want to get a count of the parents. I have seen other posts that recommend adding a blank line at the top and making everyone a child. Is there another way around this? I have attached a screen shot.

LGoller · 04/08/19

You could create a column "Children Counter" with the formula =COUNT(CHILDREN(Task1)), incrementally, in each line.

All the parents will have a value greater than zero.

Then in the cell where you want to count, use a formula such as: =COUNTIF([Children Counter]1:[Children Counter]13, >0).

You can also use a flag that turns on if the Children Counter row has a value greater than 0, or use conditional formatting that changes color based on that formula.

Finally, you could also create a report searching for the parent rows if that is helpful.

I tested it and it seems to work.

dwayne.waterman21236 · 04/09/19

Thank you! that helped.

Counting Parents on a sheet ignorning children.

Comments

Help Article Resources

Categories