nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

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

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!

Sign in to join the Community!

Quick Links

Find more posts tagged with

Formulas