How to fix #NAME? in Excel and Google Sheets
What you see
- #NAME? in cell
- Formula has a typo in the function name
Common causes
- Misspelled function like SUMA instead of SUM
- Named range does not exist
How to fix it
- Check spelling of every function name
- Ensure named ranges exist in Name Manager
- Remove stray quotes around range names