Formula errors · Short guide

#NAME in Excel? Why does the error occur?

Braxorn · Last updated 2026-11-22 · English

#NAME? Indicates that Excel does not recognize a name in the formula. A misspelled function name, undefined range name, or unquoted text can cause this issue.

What can you do?

  1. Compare the function name to Excel's autocomplete suggestion.
  2. If the formula uses a named range, examine the existence and scope of the name in the Name Manager.
  3. Make sure text constants are enclosed in quotes and that the function is supported in the version of Excel you are using.

A small example

=SUMM(A2:A5) Function names written in English are not recognized in Excel; The aggregate function is SUM. In the Turkish interface, the same function can be used under the name SUM.

What to watch for

Pasting the formula taken from the internet as it is may not work due to language or version differences. Hiding the error message alone will not fix the formula.

Check the result

Re-select the function from Excel's own suggestion and try it with a small data range.

Examples are synthetic. Formulas use English function names and comma separators; names or separators may differ with your Excel language and regional settings. Menus and features vary by version.

Microsoft source (English)

Microsoft source (English)

Review your own workbook

You can start reviewing your Excel file in Braxorn. Check which controls are supported and review incomplete checks alongside the report scope.

Review your file