# COUNTIF FORMULA FOR CHILDREN ROW WITH CRITERIA

Hello,

I'm trying to set up a formula that counts the children rows in the "Percent completed" column, per parent row. This formula will be put into Column13. But I only want to count the ones that are less than 100% completed. I'm having issues with adding in that criteria. Any suggestions?

Thanks,

• So you want a formula there only on the top row that counts all parents that have at least one child less than 100%?

• @Paul Newcome it will be a formula that counts the percent completed less than 100% for each item number.

• Ok. In that case you will need this

=COUNTIFS(DESCENDANTS([Percent completed]@row), @cell<1)

or

=COUNTIFS(CHILDREN([Percent completed]@row), @cell<1)

• Thank you Paul, the formula worked as it should. However it didn't work the way I wanted to. But now I have an idea on how to work with it. I appreciate your help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!