Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Formulas Not Working? Causes and FixesExcel formulas usually start working again after you check three things: the cell contains a formula beginning with =, the cell is…
- Excel Formulas Not Working in SharePoint? What to CheckExcel formulas do not calculate in SharePoint itself: SharePoint stores and serves the workbook, while Excel for the web or the Excel…
- Excel Formulas Not Working in a Table? Fix the CauseIf Excel formulas are not working in a table, first check that the cell is not formatted as Text, that calculation is…
- Excel Formulas Not Working Between Sheets? Fix ThemIf an Excel formula is not working between sheets, first check that it points to the right tab and cell, then confirm…
- Excel Formulas Not Working? Fix Common ProblemsExcel formulas usually stop working as expected because the cell is formatted as text, calculation is set to manual, a reference is…
- Excel Formula to Return 0 When an Error Occurs in a CellTo return 0 when a formula produces an error in Excel, wrap the calculation in IFERROR. With the value to calculate in…
- Excel Formula Not Working? Causes and FixesIf an Excel formula will not work, first check that the cell contains a formula rather than text, that the formula begins…
- Excel Formula Using Text Not Working? Find the CauseAn Excel formula that uses text usually fails because the text is not enclosed in straight double quotes, does not exactly match…
- Excel Formula to Return 0 If There’s an ErrorTo make an Excel formula return 0 whenever it produces an error, wrap it in IFERROR. If the value to calculate is…
- Excel Formula Returns 0 Instead of a Number? Fix ItIf an Excel formula returns 0 instead of the number you expect, first check whether the cell is merely formatting or rounding…
- Excel Formula Returning 0 Instead of a Value? How to Fix ItIf an Excel formula returns 0 instead of the value you expect, first check whether it is referencing a blank cell, calculating…
- Excel Formula Not Working? Fix Results Without ErrorsIf an Excel formula gives a blank, old, or incorrect result without showing an error, check calculation settings, cell formatting, the values…
- Excel Formula Not Working When Dragged Down? FixesIf an Excel formula stops working when you drag it down, first check that the fill handle is enabled and that the…
- Excel Formula Showing as Text? Fix It FastIf an Excel formula is showing as text instead of returning a result, first check whether Show Formulas is turned on; if…
- Excel Formula Not Working Until I Hit Enter?If an Excel formula updates only after you press Enter, the most common causes are that Excel is set to manual calculation…
- Excel Formula Not Updating? Fix Calculation and Data IssuesIf an Excel formula is not updating when its input values change, first check Formulas > Calculation Options > Automatic. If calculation…
- Excel Formula Drag Down Not Working? Causes and Fixes in ExcelIf an Excel formula will not drag down, first check that the fill handle is enabled: in Excel for Microsoft 365 on…
- Excel Formula Fill Down Not Working? How to Fix ItIf an Excel formula will not fill down, first check whether Excel is treating it as a formula, whether the fill handle…
- Excel COUNTIF Error? Fix Common Formula Errors FastExcel COUNTIF errors usually come from a misspelled function, an invalid reference, or criteria that do not match the cell contents as…
- Excel Circular Reference Error: Causes, Fixes, and ChecksAn Excel circular reference error means a formula refers, directly or indirectly, to its own cell. In Microsoft 365 for Windows, look…
- Excel Formula Bar Not Working? Fixes to TryIf Excel’s formula bar is not working, first turn it back on by choosing View > Show > Formula Bar. If it…
- Excel Formula Autocomplete Not Working? Fix ItIf Excel formula autocomplete is not working, first check that Formula AutoComplete is enabled under File > Options > Formulas, then type…
- Excel Find Names Missing From a List With FormulasTo find names in one Excel list that are absent from another, put the first list in A2:A100 and the list to…
- Excel FILTER Spill Error: Why It Happens and How to Fix ItAn Excel FILTER spill error means Excel cannot place the formula’s results in the cells where they need to appear. Clear the…
- Excel FILTER #REF! Error: Why It Happens and How to Fix ItIn Excel, a FILTER formula returns #REF! when it depends on a reference Excel can no longer resolve, such as a deleted…
- Excel Filter Not Grouping Dates by Year? How to FixIf Excel’s filter menu is listing individual dates instead of grouping them by year, first check that the cells contain real Excel…
- Excel FILTER #N/A Error: Causes and FixesWith records in A2:C20 and region names in C2:C20, use =FILTER(A2:C20,C2:C20="West","No matches") to return West-region rows and display a message if none…
- Excel FILTER Function Returning #N/A? Fixes That WorkIf Excel’s FILTER function shows #N/A, the error usually comes from an error value in the data or the include criteria—not simply…
- Excel FILTER Spill Error: Causes and FixesAn Excel FILTER spill error usually means Excel cannot place the returned results into the cells the formula needs. Clear or move…
- Excel FILTER Function in a Table: Fixing #SPILL!If Excel’s FILTER function returns #SPILL! because its formula is inside a table, move the formula to a blank worksheet area outside…