Excel #NAME? Error — What It Means & How to Fix It

What Does This Error Mean?

The #NAME? error in Excel means Excel does not recognize a word or text string in your formula. This is almost always a typo in a function name, a missing set of quote marks, or a named range that no longer exists. It is one of the easiest Excel errors to fix once you know where to look.

Affected Models

Microsoft Excel 2016
Microsoft Excel 2019
Microsoft Excel for Microsoft 365

Common Causes

A function name is misspelled — for example typing SUMM instead of SUM
Text in the formula is missing quotation marks around it
A named range used in the formula has been deleted or renamed
You typed a colon instead of a semicolon (or vice versa) in some regional Excel versions
An add-in function is being used but the required add-in is not installed or enabled

How to Fix It

Click the cell showing #NAME? and look at the formula bar at the top. Read the formula carefully for any misspelled function names.

Excel will auto-correct many common typos, but not all. Compare your function name against the Excel function list.
Check that any text in the formula is surrounded by double quote marks. For example: =IF(A1="Yes", 1, 0) not =IF(A1=Yes, 1, 0).

Forgetting quotes around text is one of the most common causes of #NAME? errors.
If the formula uses a named range (like =SUM(SalesData)), go to Formulas > Name Manager and check that the named range still exists.

Named ranges disappear if the sheet they referred to is deleted or if someone renamed the range.
Try typing the function name in lowercase. Excel will automatically capitalize it if it recognizes the function — this is a quick way to check spelling.

If the function stays lowercase after you press Enter, Excel does not recognize it and the name is likely misspelled.
If the formula uses an add-in function, go to File > Options > Add-ins and make sure the required add-in is enabled.

Functions from add-ins like Analysis ToolPak will show #NAME? if the add-in is disabled.

When to Call a Professional

The #NAME? error is a formula problem, not a software fault. You should be able to fix it yourself by checking the formula carefully. If your spreadsheet contains complex formulas built by someone else and you are not sure how to edit them, ask whoever created the file for help.

Frequently Asked Questions

Does #NAME? mean my Excel file is corrupted?

No. The #NAME? error is a formula problem, not a sign of file corruption. Your file is fine — Excel just cannot understand something in the formula you wrote. Fix the formula and the error will go away immediately.

Can #NAME? appear in cells I didn't change?

Yes. If you delete a named range or a sheet that other formulas reference, those formulas will suddenly show #NAME? even though you didn't touch them directly. Check the Name Manager (Formulas tab) to see if any named ranges are missing.

How do I find all the cells with #NAME? in a large spreadsheet?

Press Ctrl+H to open Find and Replace, then search for #NAME? to find all instances at once. Alternatively, use Ctrl+F to open Find, type #NAME? and click Find All to see every cell affected.