How to Fix the #NAME? Error in Excel

#NAME? means Excel found text inside a formula that it cannot identify. The formula may have a misspelled function, an unquoted text value, a missing named range, an unsupported function, or a typo in an add-in function.

Do not treat #NAME? as a calculation problem first. Treat it as a spelling and reference problem. Excel is telling you that part of the formula is not a known function, range, name, or properly quoted text value.

Check for misspelled functions

The most common cause is a simple typo in the function name:

Excel does not know SUMM, so it returns #NAME?. Fix the spelling:

This also happens with longer function names such as XLOOKUP, AVERAGEIF, NETWORKDAYS, and CONCATENATE. If the formula was typed manually, check the function name before rewriting the whole calculation.

Put text criteria in quotes

Excel also returns #NAME? when text appears in a formula without quotes. This formula is broken because Excel reads East as an undefined name:

Use quotes around literal text:

The same rule applies inside lookup formulas, conditional sums, and status logic. If the formula is checking a word, label, region, product name, or status value, that text usually needs quotes.

Check named ranges

If a formula references a named range that no longer exists, Excel may show #NAME?:

Open Name Manager and confirm the name exists, is spelled correctly, and points to the right range. In small business budget templates and project trackers, named ranges often break after someone copies a sheet, deletes a table, or renames a planning section.

Check whether the function exists in your Excel version

Modern functions such as XLOOKUP, FILTER, SORT, UNIQUE, LET, and dynamic arrays require newer versions of Excel. Older desktop versions can return #NAME? because the function itself is not available.

If the workbook needs to work across older Excel installs, use a compatible formula. For example, replace XLOOKUP with INDEX and MATCH when compatibility matters:

Common causes and fixes

Check names and text literals separately

When Excel returns #NAME?, inspect every unquoted word in the formula. A text result such as Approved needs quotes, while a defined name should not. Also check sheet names with spaces, misspelled function names, and names whose scope is limited to another worksheet. The Name Manager can reveal whether a name still points to a valid range or now resolves to #REF!.

Sources

• Microsoft Support: Detect formula errors in Excel
• Microsoft Support: How to avoid broken formulas in Excel

The Griddy way

#NAME? errors are annoying because the broken token can be buried inside a long formula. A quick spelling check is easy, but named ranges and unsupported functions take longer to trace.

"Find every #NAME? error in this workbook, identify the unrecognized function or name, and repair the formulas without changing the sheet layout"

Griddy can inspect the formulas, identify the unknown names, and update the workbook with the right function, text quotes, or restored range reference.