#NAME? usually means Excel does not recognize part of your formula.
FormulaRescue can help identify misspelled function names, missing quotes, or invalid named ranges.
=SUMM(A1:A10)Function name should likely be SUM.
=IF(A1=Yes,1,0)Text like Yes usually needs quotes.
=XLOOKUP(A2,B:B,C:C)Can show #NAME? in Excel versions that do not support XLOOKUP.
Excel does not recognize a function, named range, or text value in the formula.
Yes, common misspellings are a good fit.
Excel may read unquoted text as a name or function instead of a text value.
Paste your broken Excel formula into the main FormulaRescue tool and get a corrected version back.
Rescue a formula