Do not want Cells with "N/A" figured in my formula

Jason Cocco
Jason Cocco ✭✭
edited 12/09/19 in Formulas and Functions

=SUM(CHILDREN()) / (COUNT(CHILDREN()) + COUNTIF(CHILDREN(), ""))

I am using the above formula for percent complete in my project plan as seen by my picture. My question is when certain parts of the project have not been started yet how do you exclude the cell with the "N/A" value in it from being calculated?

Smart_Sheet.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!