This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 7.000000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
I get an error message in Microsoft 365 Lists when I try to set up a formula to calculate the average between multiple columns. All selected columns are formatted as numbers, and Totals are selected as Counts.
=AVERAGE([Col6], [Col7], [Col8], [Col9], [Col10], [Col11], [Col12], [Col13], [Col14], [Col15], [Col16], [Col17], [Col18], [Col19], [Col20], [Col21], [Col22])
Error message: A formula has a spelling mistake or refers to a column that does not exist.
The second option I have used is ColumnName and Column_Name as seen below.
=AVERAGE([Section1], [Section2], [Section3], [Section4], [Section5], [Section6], [Section7], [Section8], [Section9], [Section10], [Section11], [Section12], [Section13], [Section14], [Section15])
Error message: A formula has a spelling mistake or refers to a column that does not exist.
=AVERAGE([Section_1], [Section_2], [Section_3], [Section_4], [Section_5], [Section_6], [Section_7], [Section_8], [Section_9], [Section_10], [Section_11], [Section_12], [Section_13], [Section_14], [Section_15])
Error message: A formula has a spelling mistake or refers to a column that does not exist.
Can you please assist with resolving this issue?
Hi @Yuri Azov ,
Thanks for reaching out with your question. It appears that your question does not relate to a Microsoft Open Specifications documentation. Because of this, I've altered the tag to "SharePoint Development" in hopes that it places your question in front of the correct audience.
If your question was regarding an Open Specifications document, please reference the document in question from here: https://learn.microsoft.com/en-us/openspecs/sharepoint_protocols/MS-SPPROTLP/8a50af28-2b50-43d8-9c5a-3e520255ef7e
Michael Bowen
Microsoft Open Specifications
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 56.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
Hi @Yuri Azov ,
Good day! Welcome to Q&A forum.
A formula has a spelling mistake or refers to a column that does not exist which indicates that the column name is not correct.
Here is an example about how to set up a formula to calculate the average between multiple columns:
Create some “Number (1,1.0,100)” column: number1, number2, number3
Create a calculated column named cal with the following formula: =AVERAGE([number1],[number2],[number3]), and data type choose “Number (1,1.0,100)”:
Hope these information helps.
Please do let us know if you have any further queries.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.