AVG % that includes blank children rows
I am turning off the % complete in the project sheet setup due to a milestone (Parent) section that requires manual input of the % complete. Therefore, I need to enter formulas in the % Complete column parent to calculate the % complete for the children but it needs to include the tasks that are blank. AVG(CHILDREN()) does not work. What is the best formula to use to count the number of children and the entered % complete to find the average?
Help Article Resources
Check out the Formula Handbook template!