Counting Child Rows of Un-Checked Boxes

Elaine Wright

Any tips in how to count child rows where the check box is not checked?

I tried CountIF but it does not seem to work

Thanks

Elaine

Find more posts tagged with

Formulas

Comments

JamesR

Check boxex expect a 0 or 1 or Text. There fore if the calculation does not produce 0 or 1 then it errors.

Try this:

=COUNTIF(CHILDREN(), 0) + " of " + COUNT(CHILDREN())

JohnHinkle

James is correct, you will need to format the result as a text string (if this formula is in a checkbox cell) because the checkbox column is looking for a 1 or 0 as a result.

=COUNTIF(Complete2:Complete14, 0) + ""

The + "" at the end will format the result as a text string.

Elaine Wright

Thanks for the feedback James and John but neither one is working

J. Craig Williams

This works for me:

=COUNTIF(CHILDREN(), 0) + ""

Post a screen shot if you didn't find it yet.

Craig

Elaine Wright

J.Craig- Bingo, that one worked. Thanks!