How to Diagnose and Fix #NAME? Errors: Unquoted Strings & Function Typos

Spot why unquoted text and function typos produce #NAME? (or a silent 0 in SUMIF)

Enter four support tickets in A2:C5: TKT-1 (Billing, 18 min), TKT-2 (Tech, 32 min), TKT-3 (Billing, 24 min), and TKT-4 (Sales, 15 min). Billing minutes clearly sum to 18 + 24 = 42. Yet a learner who writes =IF(B2 = Billing, C2, 0) without double quotes around Billing immediately sees #NAME? because any bare identifier that is neither a cell coordinate nor a function name is parsed as an undefined Named Range! Even sneakier: =SUMIF(B2:B5, Billing, C2:C5) evaluates unquoted Billing to #NAME? and then silently returns 0 (instead of 42) because zero cells in B2:B5 contain that error!

Misspelling a function name—such as =SUMIFF(B2:B5, "Billing", C2:C5) or =VLOKUP(...)—also halts directly with #NAME?, as does naming a local LET variable R, C, or an A1 coordinate like r1 in Excel 365. Referencing a dedicated input cell E2 containing Billing eliminates inline quote mistakes completely and lets teammates test different queues without editing the formula.

Parameterized Cell-Reference SUMIF Formula

Place the target queue name in E2 and pass E2 directly as the second argument of SUMIF so text criteria never require manual quote escaping.

=SUMIF(B2:B5, E2, C2:C5)

Practice with a Hint-Only Prompt & Input Mutation

If you get #NAME? in a practice workbook, resist asking AI to overwrite the cell immediately. With Pro in Arte Sheets, ask: “Do not change my sheet. Point to the exact token in =SUMIF(B2:B5, Billing, C2:C5) that the formula parser treats as a defined name.” Fix the criterion to reference E2, verify 42 for Billing, then change E2 to Tech (expect 32) and to Legal (expect 0).

=IF(ISERROR(F4), "UNQUOTED_OR_UNKNOWN_NAME", F4)

Further reading

• Arte Sheets Lesson — SUMIF Category Totals and Refunds
• Arte Sheets Guide — Learn a Formula with AI Hints, Then Test It Yourself
• Microsoft Support — How to correct a #NAME? error