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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
When trying to sum a row of about 30-40 cells in Excel, I am receiving this error: #FIELD!
There are no other formulas or data type records in any of the cells. They are simple numbers (formatted as accounting) from about 30 fields.
Any suggestions would be appreciated! Thank you!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi
You did not post your formula so…:
Is there any workaround or way to disable that functionality? I'm working with some legacy code that can't be edited that defined ranges with the dot rather than a colon, and it's breaking for users with newer versions of Excel.