Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel COUNTIFS Not Working With Dates? Fix the CriteriaExcel COUNTIFS usually fails with dates because the cells contain text instead of real date values, the criteria are joined incorrectly, or…
- Excel Copy Formula Down a Column Not Working? FixesIf copying a formula down an Excel column is not working, select the formula cell and the cells below it, then choose…
- Excel CHOOSE Function Not Working? Common FixesIf Excel’s CHOOSE function is not working, first check that its index is a whole number from 1 through the number of…
- Excel AVERAGEIF Not Working? Fix Common ErrorsIf Excel AVERAGEIF is not working, first check that the criteria range, criterion, and average range are in the right order and…
- Excel Autofill Not Working? Fix Common Fill Handle IssuesIf Excel Autofill is not working, first enable the fill handle under File > Options > Advanced, then check the pattern and…
- Excel Autocomplete Not Working in One Column? FixesIf Excel’s autocomplete stops working in just one column, first check that the column contains an existing text entry beginning with the…
- Excel 3D Map Not Working? Causes, Checks, and FixesIf Excel 3D Maps is not working, first confirm that you are using the Windows desktop version of Excel: 3D Maps is…
- Excel AutoFit Column Width Not Working? Causes and FixesIf Excel AutoFit column width is not working, select the affected column or columns and choose Home > Cells > Format >…
- Exact Formula in Excel Not Working? Fix ItIf an exact formula in Excel is not working, first check that the cell is not formatted as Text, that the formula…
- Excel EXACT Function Not Working? Causes and FixesIf Excel’s EXACT function seems not to work, check whether the values differ by letter case, spaces, or hidden characters: EXACT returns…
- EDATE Function Not Working in Excel? Common FixesIf EDATE is not working in Excel, first check that its start date is a real Excel date and that its months…
- EDATE Not Working in Excel? Fix Common ErrorsIf EDATE is not working in Excel, first check that its start date is a real Excel date, that the formula is…
- Duplicate Values Not Working in Excel? How to Fix ItIf Excel is not highlighting duplicate values, first select the full range you want to check, then choose Home > Conditional Formatting…
- EDATE Formula Not Working? Fix Excel Date ErrorsIf EDATE is not working, first check that the start date is a real Excel date and that the month offset is…
- Deleting Columns in Excel Not Working? Try These FixesIf deleting columns in Excel is not working, first select the column letter, then choose Home > Cells > Delete > Delete…
- Dollar Sign Not Working in Excel? Fix Common CausesIf the dollar sign is missing in Excel, first check what you mean: press Shift+4 on a US keyboard to type the…
- Ctrl+F Not Working in Excel? Common Causes and FixesIf Ctrl+F is not finding what you expect in Excel for Microsoft 365 on Windows, open Home > Find & Select >…
- Excel Date Filter Not Working? Causes and Fixes That WorkIf an Excel date filter is not working, first check whether the cells contain real Excel dates rather than text, then confirm…
- Excel DATEVALUE Not Working? Fix Common Date ErrorsIf Excel’s DATEVALUE formula is not working, the usual cause is that the cell does not contain date text Excel can interpret…
- COUNTIFS Formula Not Working? Fix Common ErrorsIf COUNTIFS is not working, first check that every criteria range is the same size and that each range is followed by…
- COUNTIFS Function Not Working? Fix Common ErrorsIf COUNTIFS is not working, check that every criteria range has the same size and shape, then verify that each criterion matches…
- COUNTA Not Working in Excel? Fix Common Counting ErrorsIf COUNTA is not giving the result you expect in Excel, first check what is actually in the cells: it counts any…
- COUNTA Formula Not Working? Fix Common Excel IssuesCOUNTA often seems not to work because it counts cells containing formulas that return an empty string, spaces, errors, or hidden data…
- COUNTA Function Not Working in Excel? Fix ItIf COUNTA seems not to work in Excel, first check that its range includes the cells you intend to count and that…
- Excel Ctrl+F Not Working? How to Fix Excel Find IssuesIf Ctrl+F is not working in Excel, first click a worksheet cell and press Ctrl+F again; on Mac, press Command+F. If the…
- Excel CLEAN Function Not Working? Fix Hidden CharactersIf Excel’s CLEAN function seems not to work, the usual reason is that the character is not one CLEAN removes: it removes…
- Clear Filter Not Working in Excel? Fix the CauseIf Clear Filter is not bringing every row back in Excel, first choose Data > Sort & Filter > Clear while a…
- Average in Excel Not Working? Common Causes and FixesIf AVERAGE in Excel is not working, first check that the referenced cells contain numbers and that none contains an error; AVERAGE…
- Autofit Column Width in Excel Not Working? How to FixIf AutoFit Column Width is not working in Excel, select the affected columns and choose Home > Format > AutoFit Column Width,…
- Average Formula Not Working in Excel? Fix ItIf the values are in B2:B5, enter =AVERAGE(B2:B5); with 10, 20, 30, and 40 in those cells, the result is 25. If…