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)