How to correct #NAME? error
The #NAME? error in Excel means Excel doesn’t recognize something in your formula—often due to a typo, missing quotes, or an undefined name.
✅ Common Causes & Fixes for #NAME? Errors
🔹 1. Misspelled Function Name
Example:
=SUME(A1:A10) → #NAME?
Fix:
Correct to:
=SUM(A1:A10)
✅ Tip: Use Excel’s formula autocomplete to reduce spelling mistakes.
🔹 2. Missing Quotation Marks Around Text
Example:
=IF(A1=apple, "Yes", "No") → #NAME?
Fix:
Add quotes around text:
=IF(A1="apple", "Yes", "No")
🔹 3. Undefined Named Range
Example:
=SUM(SalesData) → #NAME?
If SalesData hasn’t been defined as a named range.
Fix:
- Go to Formulas > Name Manager to define or correct it.
- Or replace with an actual range:
=SUM(A1:A10)
🔹 4. Text That Looks Like a Formula or Reference
Example:
=ABC123 → #NAME?
If ABC123 isn’t a function or named range.
Fix:
- If it’s just text, put it in quotes:
="ABC123"
🔹 5. External Add-in Functions Not Available
If you’re using functions from add-ins (like EUROCONVERT), and the add-in is disabled or missing, Excel shows #NAME?.
Fix:
- Enable the add-in: File > Options > Add-ins > Manage Excel Add-ins > Go…
- Or remove the unavailable function.
✅ Use IFERROR() to Hide the Error Gracefully
=IFERROR(MyFormula, "Check formula")
But ideally, fix the cause, not just hide the error.
🛠️ Find All #NAME? Errors
- Press Ctrl + F, type
#NAME?, and click Find All to locate all occurrences.