COUNTIF FORMULA FOR CHILDREN ROW WITH CRITERIA
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?
Help Article Resources
Check out the Formula Handbook template!