Home/Excel/Resources/Common Errors
Resources

Common Excel Errors and How to Fix Them

Find every Excel error code in one place. Scan the table to the code you are seeing, then open its full explanation to learn what it means, why it happens, and exactly how to fix it.

ErrorWhat it meansCommon causeQuick fixSeen in
#####The cell contains a number, date, or time that is wider than the column can display, or a calculation resulted in a negative date.Column too narrow. The column is narrower than the value.Double-click the column border to auto-fit.DatesTimesAny
#DIV/0!A formula is trying to divide a number by zero, or by a cell that is completely empty.Divide by zero. Dividing by a blank or zero cell.Ensure the divisor holds a number; wrap in IFERROR if zero is expected.AVERAGEAVERAGEIFSMath
#NAME?Excel does not recognize a formula name or text within your formula, usually because of a simple typo.Unrecognized name. A misspelled function or unquoted text.Fix the spelling, quote literal text, or check the Name Manager.Any
#REF!A formula points at a cell that no longer exists.Invalid reference. A referenced cell was deleted.Undo the delete, or rebuild the reference.VLOOKUPINDEXAny
#N/AExcel cannot find the specific data you are asking it to look for. This error almost exclusively happens when using lookup formulas.Value not found. The lookup value isn't found.Confirm it exists, trim spaces, and use an exact match.VLOOKUPXLOOKUPINDEX
#NULL!Your formula specifies two cell ranges that do not overlap, but asks Excel to find where they cross. This is almost always caused by a missing comma.No intersection. A space instead of a comma between ranges.Replace the space with a comma.SUMAVERAGEAny
#NUM!Your formula contains or resulted in an invalid number, an impossible mathematical calculation, or a number too large for Excel to handle.Invalid number. An invalid or too-large number.Keep inputs in valid ranges; add a guess for IRR / RATE.LARGESMALLDATEDIF
#VALUE!Your formula contains a data type that does not make sense (like trying to do math on a word instead of a number).Wrong data type. Math on text, or a size mismatch.Convert text to numbers; match range sizes.VLOOKUPDatesMath
#SPILL!Your formula is trying to output results into multiple cells at once (a "spill"), but something is blocking its path.Blocked spill range. Something blocks the spill range.Clear the cells in the spill path.FILTERUNIQUESORT
#CALC!Excel is trying to calculate a list of data (an array) but ran into a logical wall, usually because a list turned out to be completely empty.Calculation error. A FILTER matched nothing.Add the if_empty argument to FILTER.FILTERLAMBDALET
#####Excel error

Column too narrow

The cell contains a number, date, or time that is wider than the column can display, or a calculation resulted in a negative date.

Find your situation
1
The column is not wide enoughMost likely
Double-click the line between the column headers at the top of the sheet to auto-fit the width, or manually drag the column wider.
2
A date or time calculation is negative
Excel cannot display negative dates or times. Check your formula to ensure you are subtracting the older date from the newer date, not the reverse.
Most common inDatesTimesAny↑ Cheat-sheet
#DIV/0!Excel error

Divide by zero

A formula is trying to divide a number by zero, or by a cell that is completely empty.

Find your situation
1
You are dividing by a blank cellMost likely
When you divide a number by an empty cell, Excel treats the blank cell as a zero. Ensure the cell you are dividing by actually contains a number.
2
An AVERAGE formula found no data
Formulas like AVERAGE or AVERAGEIFS automatically divide by the total count of items. If the cells they look at are completely empty, or no rows match your rules, it ends up dividing by zero.
3
A cell in your formula already has the error
If you try to calculate a group of cells and even just one of them contains a #DIV/0! error, your final formula will catch it and break too. Fix the original broken cell first.
Hint — If a zero is mathematically expected, you can hide this error for clean reports by wrapping your formula inside the IFERROR function (like =IFERROR(A2/B2, "No Data")).
Most common inAVERAGEAVERAGEIFSMath↑ Cheat-sheet
#NAME?Excel error

Unrecognized name

Excel does not recognize a formula name or text within your formula, usually because of a simple typo.

Find your situation
1
You misspelled the formula nameMost likely
If you type =VLOKUP instead of =VLOOKUP, Excel has no idea what you mean. Double-check the exact spelling of your formula name.
2
You forgot quotation marks around text
If you type =IF(A2=Apple) instead of ="Apple", Excel thinks "Apple" is a custom formula that doesn't exist. Always wrap plain text in quotation marks.
3
You deleted or misspelled a Named Range
If your formula references a custom named range (like =SUM(SalesData)), and you accidentally delete that name or spell it incorrectly, it will break. Check your Formulas → Name Manager.
4
You are using an older version of Excel
If you try to use a newer function (like XLOOKUP or FILTER) on an older version of Excel (like Excel 2016), or a custom function that requires an add-in, Excel will not recognize the name.
5
Your Excel is in a different language
Excel translates formula names based on your installation language. For example, if your Excel is set to German, you must type SUMME instead of SUM. If you paste an English formula into a foreign-language Excel, it will break.
6
You forgot the colon in a cell range
If you type =SUM(A1A10) instead of =SUM(A1:A10), Excel thinks you are typing a custom word instead of selecting a group of cells. Always include the colon (:) between your starting and ending cells.
Most common inAny↑ Cheat-sheet
#REF!Excel error

Invalid reference

A formula points at a cell that no longer exists.

Find your situation
1
You deleted a row or column a formula was usingMost likely
If you delete a cell that another formula relies on, the reference is destroyed forever. Press Ctrl+Z immediately — undoing the action is the only way to bring the reference back.
2
You copied a formula without locking its references ($)
When you copy a formula, Excel automatically shifts its cell references based on where you paste it. If you paste the formula into a cell that forces it to look outside the spreadsheet boundaries (like asking for a row above Row 1, or a column before Column A), it breaks and returns a #REF! error. You can fix this by adding dollar signs (like $A$1) to lock your references in place before copying.
3
Your formula is asking for a row or column that does not exist
If a lookup formula (like VLOOKUP, HLOOKUP, INDEX, OFFSET, etc.) is given a search area of 3 columns, but you tell it to extract data from column 4, Excel returns a #REF! error because that column doesn't exist inside your selection. Ensure your index number is not larger than your selected table.
4
An INDIRECT formula points to a missing sheet
If you use the INDIRECT function to build a text reference (like "Sheet2!A1"), but "Sheet2" is deleted or renamed, the reference instantly breaks. Double-check your sheet names.
5
A link to another workbook broke
If your formula pulls data from a completely different Excel file, and that file is moved, renamed, or deleted, the link breaks. Restore the file, or repair it by going to Data → Edit Links.
Hint — Prefer INDEX/MATCH or XLOOKUP over VLOOKUP — they survive column deletes and shifts far better, preventing #REF! errors entirely.
Most common inVLOOKUPINDEXAny↑ Cheat-sheet
#N/AExcel error

Value not found

Excel cannot find the specific data you are asking it to look for. This error almost exclusively happens when using lookup formulas.

Find your situation
1
The value simply does not exist in your dataMost likely
If you ask a formula to find "Apple", but "Apple" is nowhere in your source data, Excel returns #N/A. Double-check that the item you are searching for actually exists in the list.
2
Extra spaces or invisible characters
"Apple" is not the same as "Apple ". If your search word or your source data has accidental spaces at the end, Excel will not find a match. Use the TRIM function to clean your data.
3
Numbers stored as text
If you are searching for the number 123, but your source table has 123 stored as text (often marked by a small green triangle in the corner of the cell), Excel sees them as completely different things. You must convert the text back to numbers.
4
You forgot to lock your search area ($)
If you copy a lookup formula down a column without locking the search area with dollar signs (like $A$1:$C$100), the search area slides downward. Eventually, it slides completely past your data, returning #N/A because the area it is searching is empty.
5
You forgot the EXACT MATCH rule in your formula
If you leave off the exact match flag (like FALSE or 0) at the end of formulas like VLOOKUP, HLOOKUP, or MATCH, Excel defaults to an "approximate" match. Approximate matches require your data to be sorted in ascending order (A–Z). If your data is unsorted, the formula will break and return #N/A even if the value actually exists. Always end these formulas with FALSE or 0.
6
A cell in your formula already has the error
If any cell referenced inside your formula already contains an #N/A error, that error will travel up the chain and cause your primary formula to return #N/A as well. Fix the original broken cell first.
Hint — If it is normal and expected that some items will not be found, wrap your formula inside the IFNA function to display a clean message instead of an error (like =IFNA(VLOOKUP(...), "Not Found")).
Most common inVLOOKUPXLOOKUPINDEXMATCH↑ Cheat-sheet
#NULL!Excel error

No intersection

Your formula specifies two cell ranges that do not overlap, but asks Excel to find where they cross. This is almost always caused by a missing comma.

Find your situation
1
You forgot a comma between cells or rangesMost likely
If you type =SUM(A1 A10) instead of =SUM(A1, A10), or =SUM(A1:A5 B1:B5) instead of =SUM(A1:A5, B1:B5), you have accidentally put a space between them. In Excel, a space is a special command asking it to find where the two areas overlap. Since they do not touch, it returns #NULL!. Replace the space with a comma.
2
You forgot a math operator (like +, -, *, /)
If you type =A1 A10 instead of =A1+A10, Excel thinks the space is the overlap command. If you meant to add, subtract, multiply, or divide the cells, replace the space with the correct math symbol.
3
You wanted the overlap, but the ranges do not touch
If you intentionally used a space to find the exact cell where two ranges cross (like =SUM(A1:C5 B3:D7)), but you accidentally selected ranges that do not physically touch each other on the grid, Excel returns #NULL!.
Most common inSUMAVERAGEAny↑ Cheat-sheet
#NUM!Excel error

Invalid number

Your formula contains or resulted in an invalid number, an impossible mathematical calculation, or a number too large for Excel to handle.

Find your situation
1
You provided an invalid number or boundaryMost likely
If you break the strict numerical rules of a formula, Excel returns #NUM!. For example:
  • LARGE / SMALL: Asking for the 10th item in a list that only has 5 items.
  • RANDBETWEEN: Setting the "bottom" number higher than the "top" number.
  • PERCENTILE: Entering a percentage outside the strict 0 to 1 range.
2
A date formula is calculating backward
Formulas that calculate the difference between dates (like DATEDIF) require the older "start date" to come first. If you put them in backward so the start date is newer than the end date, it results in a negative time difference and returns #NUM!.
3
An impossible math calculation
You are asking Excel to perform math that does not exist in the real world, such as finding the square root of a negative number (e.g., =SQRT(-1)). Check your inputs to ensure they are mathematically possible.
4
The resulting number is simply too massive
Excel has limits. It can only handle numbers between -1x10^307 and 1x10^307. If your formula multiplies or powers numbers into something larger than that massive limit (like =1000^1000), Excel gives up and returns #NUM!.
5
A financial formula cannot find an answer
Formulas like IRR or RATE use complex math that guesses the answer over and over until it gets it right. If it cannot find a solution after 20 tries, it returns #NUM!. You can fix this by adding a comma and a manual "guess" number at the very end of your formula to help it start in the right direction.
6
A cell in your formula already has the error
If any cell referenced inside your formula already contains a #NUM! error, that error will travel up the chain and cause your primary formula to return #NUM! as well. Fix the original broken cell first.
Most common inLARGESMALLDATEDIFRANDBETWEENPERCENTILEMathFinancial↑ Cheat-sheet
#VALUE!Excel error

Wrong data type

Your formula contains a data type that does not make sense (like trying to do math on a word instead of a number).

Find your situation
1
You are trying to do math on textMost likely
If you try to add, subtract, multiply, or divide a word (like =5+"Apple"), Excel gets confused and returns #VALUE!. Check the cells you are calculating to ensure they all contain actual numbers.
2
Hidden spaces are turning numbers into text
If a cell looks like a number but has a hidden space typed after it (like "5 "), Excel treats the entire cell as a word. When you try to do math on it, it returns #VALUE!. Use the TRIM function or Find & Replace to remove accidental spaces.
3
You used text where a number, date, or logic is strictly required
Many formulas are designed exclusively for specific inputs (like numbers, dates, or TRUE/FALSE logic). If you give them a plain text word instead, they will break and return #VALUE!. For example, if you give a date formula a word like "Tomorrow", or an invalid date like "Feb 30th", Excel cannot process it.
4
Your formula's row or column number is 0 or negative
If you type 0 or a negative number as the index number in a lookup formula (like VLOOKUP, HLOOKUP, INDEX, etc.), Excel returns #VALUE! because row and column numbers must start at 1. (Note: If the number is too large, it returns #REF! instead.)
5
You gave a range when a single cell was expected
Some basic formulas only work on one cell at a time. If you tell a formula to look at an entire column (like =A1:A100 + 5), older versions of Excel will break and return #VALUE! because they do not know how to handle multiple cells at once.
6
A cell in your formula already has the error
If any cell referenced inside your formula already contains a #VALUE! error, that error will travel up the chain and cause your primary formula to return #VALUE! as well. Fix the original broken cell first.
7
You selected ranges of different sizes
If a formula requires you to select multiple groups of cells (like XLOOKUP, FILTER, or SUMPRODUCT), those groups usually must be exactly the same size. If you select 10 rows for your first group but only 9 rows for your second group, Excel cannot match them up and returns #VALUE!.
Most common inVLOOKUPDatesMathAny↑ Cheat-sheet
#SPILL!Excel error

Blocked spill range

Your formula is trying to output results into multiple cells at once (a "spill"), but something is blocking its path.

Find your situation
1
A cell in the spill area already contains dataMost likely
Your formula is designed to output a list of answers (like FILTER or UNIQUE), but one of the blank cells it needs to use already has text, numbers, or another formula inside it. Excel will not delete your existing data, so it stops and throws a #SPILL! error instead. Delete the blocking data to let it flow.
2
An invisible space character is blocking the spill area
Even if the cells below your formula look perfectly empty, one of them might contain a single, invisible spacebar character. Excel sees that space as "data" and stops the spill. Highlight the seemingly empty cells below your formula and press the Delete key on your keyboard to clear them out.
3
You are trying to spill into merged cells
Spill formulas cannot output data into merged cells. If any cell in the expected drop zone is merged with another cell, the formula will break. Unmerge the cells in its path to fix it.
4
You are typing the formula inside an Excel Table
Spill formulas do not work inside official Excel Tables (the ones created via Insert > Table). If you type a spill formula inside an official Table, it will instantly return #SPILL!. You must use these formulas in normal grid cells outside of the Table.
5
You ran out of space on the spreadsheet
If you try to spill an entire column's worth of data (like =A:A), but you type the formula in row 2, it will try to push past the very bottom row of the entire spreadsheet (row 1,048,576). Because it runs out of physical grid space, it returns #SPILL!. Select a specific range (like A1:A500) instead of the entire column.
Most common inFILTERUNIQUESORTSORTBYSEQUENCE↑ Cheat-sheet
#CALC!Excel error

Calculation error

Excel is trying to calculate a list of data (an array) but ran into a logical wall, usually because a list turned out to be completely empty.

Find your situation
1
Your FILTER formula found zero matchesMost likely
If you use the FILTER formula to search for data, but absolutely no rows match your criteria, Excel doesn't know what to display. Instead of leaving the cell blank, it throws a #CALC! error. To fix this, always fill out the optional [if_empty] argument at the very end of your FILTER formula (like =FILTER(..., "No results found")).
2
You are trying to put a list inside a list
Modern Excel lets you output lists of data. However, it cannot handle putting a list inside another list (known as a "nested array"). If your formula tries to combine multiple spilling lists into a complex structure that Excel cannot draw on the flat grid, it returns #CALC!.
3
You built a custom LAMBDA formula that broke
LAMBDA is an advanced feature that lets you build your own custom formulas from scratch. If your custom LAMBDA formula has a math error, a typo, or gets stuck in a loop, Excel will stop it and display #CALC!.
4
You forgot the final step in a LET formula
The LET formula allows you to name pieces of your calculation to use later. However, after naming all your pieces, you must always provide a final calculation at the very end of the formula. If you define your names but forget to give it a final math problem to solve, it returns #CALC!.
5
Your formula is trying to read and write to the exact same cells
If a spill formula (like FILTER, UNIQUE, or SORT) tries to read data from the exact same cells it is trying to output its answers into, it creates an infinite loop. Instead of crashing your computer, Excel safely halts the formula and returns #CALC!.
Most common inFILTERLAMBDALETSORTArray↑ Cheat-sheet