Column Formula to Average several other adjacent columns
I am trying to set up a survey sheet that gathers data through a form to have a constant formula in a column "Average Score". I can't find any specifics about how to build the formula only that referencing specific cells is not allowed. Here is my current formula
I know it needs to be revised to @row somehow, but not sure the syntax
Help Article Resources
Check out the Formula Handbook template!