Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Google Sheets COUNTIF Not Working? Fix Common CausesIf Google Sheets COUNTIF is not working, first check that the range and criterion match the data exactly, then confirm the formula…
- Excel #SPILL! Error: How to Find and Fix ItTo get rid of a #SPILL! error in Excel for Microsoft 365 on Windows, select the error cell, read the message beside…
- Excel #NAME? Error: How to Fix ItIf Excel displays #NAME?, it cannot recognize text in the formula, such as a misspelled function, an undefined name, or text that…
- Excel #VALUE! Error: How to Find and Fix the CauseExcel’s #VALUE! error means a formula received a value or argument in a form it cannot use. Find the cell or function…
- FindTime Not Working in Outlook? Fix Scheduling PollIf FindTime is not working in Outlook, look for Scheduling Poll: Microsoft replaced the FindTime add-in with this feature, so reinstalling the…
- Fix VLOOKUP Not Working: Causes and SolutionsTo fix VLOOKUP in Microsoft Excel for Microsoft 365, check that the lookup value is in the first column of the selected…
- Excel #DIV/0! Error: Causes, Fixes, and PreventionTo get rid of #DIV/0! in Excel, fix the calculation so its divisor is not zero or blank; if zero is a…
- Find and Replace Not Working in Word? Fixes That HelpIf Find and Replace is not working in Word, first open Home > Replace on Windows and check that the search text,…
- Find Not Working in Word? Troubleshooting Search IssuesIf Find is not working in Microsoft Word, first check that you are searching the right document and that no search options…
- Excel VLOOKUP Value Not Available Error?In Excel, the VLOOKUP “value not available” error is usually #N/A: Excel cannot find the lookup value in the first column of…
- Excel WORKDAY Function Not Working? How to Fix ItIf Excel’s WORKDAY function returns an error or an unexpected date, first check that the start date is a real Excel date,…
- Excel XLOOKUP Value Error? How to Find and Fix It FastAn Excel XLOOKUP #VALUE! error most often means the lookup array and return array do not have matching dimensions, or the formula…
- Excel VLOOKUP #N/A: Why a Visible Value Won’t MatchExcel VLOOKUP returns #N/A when it cannot find the lookup value in the first column of its search range, even if a…
- Excel VLOOKUP Spill Error: Causes and FixesAn Excel VLOOKUP spill error, shown as #SPILL!, means the formula is returning multiple results but Excel cannot place them in the…
- Excel VLOOKUP #REF! Error: Causes, Fixes, and PreventionA VLOOKUP #REF! error means Excel cannot use a reference required by the formula. Most often, the formula asks for a return…
- Excel Value Error When Adding Blank Cells: Causes and FixesIf Excel shows #VALUE! when you add cells that look blank, at least one cell usually contains text—often a formula returning an…
- Excel #N/A Error: What It Means and How to Fix It QuicklyIn Excel, the #N/A error means that a formula cannot find a value it needs, most often because a lookup has no…
- Excel Unique Name Error: Why It Appears and How to Fix ItIf Excel says a name is already taken or must be unique, the name you are trying to assign conflicts with an…
- Excel Value Error: Why It Appears and How to Fix ItExcel’s #VALUE! error means a formula received a value or argument it cannot use in that calculation; it is not truly random.…
- Excel Text Wrap Not Working? Fix Row Height and Cell LayoutIf Excel text wrap is not working, turn on Home > Alignment > Wrap Text, then make sure the row is tall…
- Excel UNIQUE Spill Error: Causes, Fixes, and ChecksAn Excel UNIQUE spill error usually means the results cannot fit in the cells where the formula needs to return them. Clear…
- Excel SUMIFS #VALUE! Error: Causes and FixesIn Excel, SUMIFS most commonly returns #VALUE! when its sum range and one or more criteria ranges have different dimensions. Make those…
- Excel Table Name Already Exists Error: How to Fix ItThe Excel table name already exists error means the name you entered is already assigned to another table in the workbook, or…
- Excel #VALUE! Error: How to Test for It in a CellTo test whether cell A2 specifically contains Excel’s #VALUE! error, use =IFERROR(ERROR.TYPE(A2)=3,FALSE). It returns TRUE for #VALUE!, FALSE for other errors or…
- Excel SUMIF Not Working on Calculated Data?Excel SUMIF can sum calculated data: it works with cells containing formulas as well as cells containing typed values, provided the results…
- Excel Stale Value Error: What It Means and How to Fix ItExcel’s “stale value” is usually not a standard formula error such as #VALUE!; it means a displayed result may not reflect the…
- Excel SUMIF Quotation Marks Not Working? Fix the CriteriaIf Excel SUMIF quotation marks are not working, first check that text criteria use straight double quotation marks and that any comparison…
- Excel Zero Error: Why #DIV/0! Appears and How to Fix ItIn Excel, a “zero error” usually means the #DIV/0! error: a formula is dividing a number by zero or by a blank…
- Excel Spill Error: Causes, Fixes, and ExamplesAn Excel spill error, shown as #SPILL!, means a formula that returns multiple results cannot place them all in the worksheet. Select…
- Excel Spill Error: Causes, Fixes, and Clear ExamplesTo fix an Excel spill error, select the cell showing #SPILL!, identify what is blocking the formula’s intended output range, and clear…