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)


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!