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

SharonR

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())

Paul Newcome

Wrap your formula in the red row in an IFERROR statement. That should remove the error and allow the other formulas to run.

=IFERROR(original_formula, "")