Average Formula Issue

Hi there, i am trying to average cells that were built up by formulas.

So basically the Column 1-7 are the scores when the task is done , it will turns into 100 when the task is complete, and where the right handside column would need to average the score of column 1-7.

When I tried to average , it turns out "UNPARSEABLE" ; Below is the formula I tried to create.

(I also tried Average ISERROR, if also didn't work)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!