Excel #NAME? Error: How to Fix It

If Excel displays #NAME?, it cannot recognize text in the formula, such as a misspelled function, an undefined name, or text that should be enclosed in quotation marks. Check the formula for spelling and punctuation first, then verify any named ranges and confirm that your Excel version supports the functions it uses.

What the #NAME? error means

Excel formulas combine functions, cell references, operators, names, and sometimes text. When Excel cannot interpret a word or name in a formula, it returns #NAME? rather than calculating a result. The error points to something Excel does not recognize; it does not necessarily mean the entire formula is invalid. A single misspelled function or missing quote can be enough.

For example, Excel recognizes SUM but not a made-up spelling such as SUUM. It also treats an unquoted word in a formula as a possible defined name, not automatically as ordinary text. If that name has not been defined, the result can be #NAME?.

This error is different from #REF!, which usually means a formula refers to a cell or range that is no longer valid, and #VALUE!, which indicates a problem with the type or arrangement of a value. The distinction helps narrow down what to inspect.

Common causes of #NAME? in Excel

Look for these frequent causes before changing the formula’s underlying logic:

A misspelled function: A typo in a function name, such as AVERGE instead of AVERAGE, prevents Excel from recognizing it.
Text without quotation marks: Text used as a formula value generally needs straight double quotation marks. Without them, Excel may interpret the word as a name.
An undefined or misspelled defined name: A formula may use a name that was never created, was deleted, or is spelled differently in Name Manager.
A missing colon in a range: A range written incorrectly may be interpreted as a name. Check that a range such as A1 through A10 uses a colon between its endpoints.
A misspelled table or column name: Structured references rely on the table and column labels that actually exist in the workbook.
A function unavailable in the current Excel version: A workbook created with a newer function may not calculate correctly in an older Excel release.
An add-in or custom function that is unavailable: A formula may rely on a function supplied by an add-in or VBA code that is not active or present on this computer.

Do not assume every word in a formula should be quoted. Function names, cell references, and defined names are not text literals. Add quotes only where the formula is meant to compare, return, or otherwise use literal text.

How to find the part Excel cannot recognize

Select the cell and read the formula in the formula bar. If it is long, click in the formula bar or press F2 on Windows to inspect it in the cell. Look for a word that is not a cell reference or a valid function, and check where quotes, parentheses, commas, and range separators begin and end. Excel’s formula-coloring can also help distinguish references from other parts of the expression.

Check each function name against Excel’s function suggestions as you edit the formula.
Compare every named range and table or column name with the spelling used in the workbook.
Look for text values that need straight double quotation marks.
If the formula uses a recent function, check whether the computer opening the file has a compatible Excel version.
Use Formulas > Evaluate Formula to step through how Excel evaluates parts of a formula. This can help expose the point where an unrecognized name appears.

For a simple formula, temporarily remove or select parts of the expression to isolate the problem, but avoid overwriting the only copy of a complex formula. Copy it to a safe place first. If Excel’s error-checking indicator appears in the cell, selecting it may offer a relevant suggestion, though suggestions do not identify every cause.

Fix misspelled functions and unquoted text

Correct the function name using Excel’s spelling and AutoComplete suggestions, then check that the function’s parentheses and arguments are complete. A function name must be followed by the appropriate opening parenthesis when the function takes arguments. Argument separators are commonly commas in an English-language installation, but regional settings can use semicolons; use the separator Excel expects on that computer.

For example, with the word Paid in A2, use this formula to return a status. The assumed layout is that cell A2 contains the text Paid; the formula returns Complete.

=IF(A2="Paid","Complete","Open")

Here, Paid, Complete, and Open are text values, so they are enclosed in straight double quotation marks. If the quotes are omitted, Excel may interpret one of those words as a defined name. Curly quotation marks copied from a document are not a safe substitute for the straight quotation marks used in formulas.

When a formula includes a text condition, also check that the text matches the cell value. A spelling difference may not cause #NAME? if the text is quoted, but it can cause the formula to return an unexpected result. This is one reason to separate “Excel cannot parse this” errors from ordinary logic or matching problems.

Check named ranges and table references

A defined name is a label assigned to a cell, range, constant, or formula so it can be used in other formulas. Open Formulas > Name Manager to see existing names, their references, and their scope. Confirm that the name in the formula exists, is spelled exactly the same way, and refers to the intended cells. A name can be limited to a particular worksheet, so a formula on another sheet may not be able to use it as expected.

For example, suppose the workbook has a defined name called MonthlySales that refers to B2:B10. With that name in place, the formula below adds the cells in that named range. Its assumed layout is MonthlySales referring to the nine sales values in B2:B10; if those values total 450, the result is 450.

=SUM(MonthlySales)

If the name is absent or has a different spelling, the formula may return #NAME?. Create or correct a name only if it is intended to be part of the workbook; otherwise, replace it with the correct cell or range reference. For tables, select a formula cell and compare its structured reference with the actual table and column headers. Renaming a column or table can affect formulas that refer to it.

Check quotes, range punctuation, and sheet references

Ordinary text in a formula is enclosed in straight double quotation marks. Sheet names are different: a sheet reference uses an exclamation mark between the sheet name and the cell reference, and a sheet name containing spaces or punctuation is enclosed in straight single quotation marks. For example, a reference to cell A1 on a sheet named Sales Data is written as 'Sales Data'!A1. Do not confuse the single quotes used around a sheet name with the double quotes used around text values.

For ranges, check that the start and end references are separated by a colon. A comma usually separates function arguments, while a colon identifies a range; these symbols serve different purposes. A missing or misplaced punctuation mark can make Excel read a word or fragment as a name. If you are unsure of the syntax, build the reference by selecting the cells with the mouse while editing the formula rather than typing the entire reference manually.

When a function is not supported

Microsoft 365 for Windows includes many functions that are absent from older Excel versions. Functions including XLOOKUP, XMATCH, FILTER, SORT, UNIQUE, SEQUENCE, and LET require Excel 2021 or Microsoft 365. Functions including LAMBDA, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, and HSTACK require Microsoft 365 or Excel 2024. Availability can also depend on updates and the platform being used.

If a workbook containing a newer function is opened in an older version, the formula may not be recognized or may display a compatibility marker such as _xlfn.. Update Excel where possible, or ask the workbook’s author to provide a version-compatible alternative. Avoid replacing a function until you understand what it does: a substitute may calculate differently, especially when a formula handles errors, arrays, or approximate matches.

Excel for the web supports many Microsoft 365 functions, but it does not run VBA macros. If a formula uses a custom VBA function, open the workbook in desktop Excel with the relevant macro code available and enabled, subject to your organization’s security settings. Add-in functions likewise require the corresponding add-in to be installed and available. A workbook can therefore work on its author’s computer but fail elsewhere if its dependencies are missing.

Prevent the error when sharing workbooks

Before sharing a workbook, check formulas on a computer or account similar to the recipient’s, particularly if the file uses newer functions, add-ins, or macros. Prefer standard Excel functions when broad compatibility matters, and document any required add-ins or custom functions. If a formula depends on a named range, keep the name in the workbook and avoid deleting or renaming it casually.

When writing formulas, use Excel’s function suggestions and select references directly where practical. After editing a table header or a defined name, review dependent formulas. If you receive a workbook showing errors, ask which Excel version created it and whether it relies on add-ins or custom code. Those details can explain an error that is not caused by a simple typo.

Frequently Asked Questions

Why does Excel say #NAME? when I type a formula?
Excel is finding a name or function it cannot recognize. Check the spelling of function names, any defined names, and whether literal text is enclosed in straight double quotation marks. Also check that the formula uses the argument separator expected by your regional settings.

How do I fix #NAME? in Excel for Microsoft 365?
Inspect the formula, correct misspellings or missing quotes, and check any names in Formulas > Name Manager. If the formula uses an add-in function or custom function, confirm that its add-in or code is available. Microsoft 365 supports many recent functions, but a missing dependency can still cause trouble.

Can a missing quotation mark cause #NAME?
Yes. If a word intended as text is not enclosed in straight double quotation marks, Excel may treat it as a defined name. Add quotes around the text value, while leaving function names, cell references, and actual defined names unquoted.

Why does a formula work on one computer but show #NAME? on another?
The computers may have different Excel versions, installed add-ins, or available custom VBA functions. The recipient may also lack a defined name or be using a platform that does not support a feature used by the workbook. Check those dependencies before rewriting the formula.

Does #NAME? mean the cell reference is broken?
Usually, no. An invalid or deleted cell reference more commonly produces #REF!. For #NAME?, start by checking function names, defined names, unquoted text, and version or add-in compatibility.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.