AVERAGEIF or AVG ??????Why is this not working and how do i get it to work


So i basically want to calculate the average of all completed query. In the picture above there is a formula that calculates how long the task takes. If is not complete it does not have a data and the formula will show the #error above..... this i think is where i am going wrong i just dont know how to change it... Please help

the formulas i though should work in the purple #invalid data type is =AVERAGEIF(CHILDREN(Completed91), ="Completed", CHILDREN())



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!