=COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) Formula help!

AmandaC

Currently using =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) with check-boxes as a quick look to tell how many deliverables have currently been accounted for. I need to add additional lines under the parent row, but don't want them to count toward the total shown at the top. Is there a way to do this?

Screen Shot 2021-10-28 at 3.42.45 PM.png

Genevieve P.

Hi @AmandaC

Will there be any defining detail on these additional rules that will allow you to exclude them from the total count?

For example, if these additional rows all say "Test" in a certain cell, you could use a COUNTIF instead of a COUNT as the second half of your formula:

=COUNTIF(CHILDREN(), 1) + " of " + COUNTIF(CHILDREN([Specific Column]@row), <> "Test")

Let me know if that makes sense! I'd be happy to help further but it would be useful to know more about these addition rows and why you want to exclude them.

Cheers,

Genevieve