Looking to create a formula to count number of tasks
On the "Corporate Legal" row the formula in the "0 of 8" is the following:
=COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN())
I want to create a Parent Count for all tasks. There are other sections with the same setup. I want the parent section (the cell with a blue border) to count all number of tasks.
So if I have "0 of 8" and "5 of 10", the parent total shall show "5 of 18".
Please help, thank you!
Best Answers

Sorry about that. I had initially missed that the other rows were not indented below the top row. Try this instead...
=COUNTIFS(Done:Done, 1) + " of " + COUNTIFS(Done:Done, NOT(ISTEXT(@cell)))

If the rows ARE indented, then you should be able to use the DESCENDANTS function.
Answers

Try using the DESCENDANTS function instead of the CHILDREN function for the top total.

Unfortunately, that did not fix the issue.

Sorry about that. I had initially missed that the other rows were not indented below the top row. Try this instead...
=COUNTIFS(Done:Done, 1) + " of " + COUNTIFS(Done:Done, NOT(ISTEXT(@cell)))

Thank you, @Paul Newcome . What suggestions do you have that if I did indent the rows underneath the top row? What does that do for the formulas? I am trying to simplify as much as I can.

If the rows ARE indented, then you should be able to use the DESCENDANTS function.

Thanks again @Paul Newcome , this worked well. I appreciate the help.

Help Article Resources
Categories
Check out the Formula Handbook template!