Looking to create a formula to count number of tasks

Cuatro

CountIF.jpg

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!

Paul Newcome

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)))

Paul Newcome

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

Paul Newcome

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

Cuatro

Unfortunately, that did not fix the issue.

Paul Newcome

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)))

Cuatro

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.

Paul Newcome

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

Cuatro

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

Paul Newcome

Happy to help. 👍️