A formula parse error in Google Sheets, shown as #ERROR!, means Sheets cannot read the formula as written. It is not about your data. The usual causes are a missing bracket or quote, a comma where your locale needs a semicolon, or curly quotes pasted in from a chat or document.
What are the common causes of a parse error?
- Brackets that do not match: =SUMIFS(B2:B100,C2:C100,"Food" has no closing bracket.
- Quotes that do not match: ="Food in a formula with one opening quote.
- Curly quotes pasted from WhatsApp, Word or a web page. Sheets wants straight quotes. Retype them in the formula bar.
- The wrong separator: your locale may expect semicolons between arguments instead of commas.
- A stray symbol, such as a rupee sign typed into a formula, outside quotes.
Why do commas stop working in some sheets?
Each spreadsheet has a locale setting under File, Settings. In locales where a comma is the decimal separator, formulas use semicolons between arguments: =SUMIFS(B2:B100;C2:C100;"Food"). A formula copied from a guide written for a comma locale gives a parse error. Check File, Settings, Locale. If you work with a template from someone abroad, the locale can be different from yours.
How do I find the mistake quickly?
- Click the cell and read the hover message. For a parse error it says Formula parse error.
- Count the brackets: every opening bracket needs a closing one. Write the count of opening and closing brackets on paper if the formula is long.
- Check the quotes around each piece of text.
- Break a long formula into smaller parts in separate cells and add them back together.
- Retype any straight quote that was pasted.
How is a parse error different from other Sheets errors?
A parse error is about the shape of the formula. The others are about what the formula found when it ran. Here are the common messages:
| Message | Usual meaning | First thing to try |
|---|---|---|
| #ERROR! with Formula parse error | Sheets cannot read the formula | Brackets, quotes, separators |
| #N/A | A lookup did not find the value | Check spelling and extra spaces in the value |
| #REF! | A reference points at nothing; or an array result would overwrite data | Clear the cells the result needs |
| #VALUE! | A value of the wrong type | Look for text in a number cell |
| #DIV/0! | Division by zero | Test the divisor with IF |
| #NAME? | A function or name is not recognised | Spelling and quotes |
| #NUM! | A number is out of range or impossible | Check dates and inputs |
| Circular dependency detected | A formula refers to its own cell | Move the formula out of its own range |
Why does a formula copied from a guide fail when it looks right?
Text copied from a web page or chat can carry characters you cannot see: curly quotes, a non-breaking space, or a long dash in place of a minus sign. They look identical to the real thing and fail in the formula. If a copied formula fails only on your sheet, retype the quotes and operators by hand and check the locale before you suspect anything else.
How do I stop it recurring?
- Type formulas in the formula bar rather than pasting them from a chat app.
- If you do paste, retype every quote mark.
- Build long formulas one function at a time, checking each result.
- Keep one tested formula per task in a notes tab, so you copy from your own sheet.
If you reach the point where the sheet is mostly formulas to categorise statement lines, SpendixAI can categorise imported rows with your own rules, then your history, and show the results in reports; formulas then only cover what you want to calculate yourself.
Quick checklist
- Hover over the cell and read the message.
- Check locale under File, Settings.
- Count brackets and quotes.
- Retype straight quotes.
- Split the formula into pieces.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


