Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Value Error When Multiplying: Causes and FixesA #VALUE! error when multiplying in Excel usually means at least one value in the calculation is text or another kind of…
- Excel Date Subtraction #VALUE! Error: Causes and FixesA #VALUE! error when subtracting dates in Excel usually means that at least one cell is text Excel cannot use as a…
- VLOOKUP #VALUE! Error: Causes and FixesA VLOOKUP formula returns #VALUE! most often when its column index argument is less than 1, or when the lookup value is…
- Excel FILTER #VALUE! Error: Causes and FixesIn Excel, FILTER most commonly returns #VALUE! when its include argument does not have the same number of rows or columns as…
- XLOOKUP #VALUE! Error: Causes and FixesA #VALUE! error in XLOOKUP most often means the lookup range and return range do not have matching dimensions along the direction…
- Text Wrap Not Working in Word? Fix Image Text FlowIf text will not wrap around a picture in Word, select the picture and choose Picture Format > Arrange > Wrap Text,…
- Excel Text Wrapping Not Working? Fix the Common CausesIf text wrapping is not working in Excel, select the affected cells and choose Home > Wrap Text, then make sure the…
- VLOOKUP Not Working? Fix Common Excel Lookup ErrorsIf VLOOKUP is not working, first check that the lookup value is in the leftmost column of the selected range and use…
- SUMIFS Wildcard Not Working? Common FixesIf SUMIFS wildcards are not working, check that the wildcard is inside a quoted text criterion and that the criteria range contains…
- SUMIFS Value Error? Fix #VALUE! in ExcelA SUMIFS formula that returns #VALUE! most often has sum and criteria ranges that are different sizes or shapes. Make every criteria…
- SUMIFS With Three Criteria Not Working? Fix ItIf SUMIFS with three criteria is not working, check that the formula has one sum range followed by three correctly paired criteria-range…
- SUMIFS Not Working With Blanks? Fix the CriteriaWhen you want to sum rows whose criteria cells are blank, use an explicit empty-string criterion: with categories in A2:A100 and amounts…
- SUMIFS Not Working With Dates? Fix Common Date CriteriaYes—SUMIFS can sum values by date, but the criteria must match Excel’s underlying date values, not just the way dates look on…
- SUMIFS Not Working With Multiple Criteria? Common FixesWhen SUMIFS is not working with multiple criteria, first check that its arguments are in the right order and that every criteria…
- SUMIFS Not Working? Fix Common Excel ErrorsIf SUMIFS is returning the wrong total, check that the sum range and every criteria range cover matching cells, then verify that…
- SUMIF Not Working With Text? Fix Common Criteria IssuesYes—Excel’s SUMIF can use text as its criterion, such as a department name or product label, while adding the corresponding numeric values.…
- SUMIFS Between Dates Not Working? Common FixesIf your dates are in A2:A100, amounts are in B2:B100, and the start and end dates are in D2 and E2, use…
- SUMIF Not Working With Merged Cells? Causes and FixesYes—merged cells can make SUMIF appear not to work because Excel stores a merged area’s value only in its upper-left cell. If…
- SUMIF Not Working in Excel? How to Find and Fix ErrorsIf SUMIF is not working in Excel, first check that the criteria range and sum range cover the intended rows, then confirm…
- SUMIF Not Working? Fix Common Excel ErrorsIf SUMIF is not working in Excel, check that its criteria match the actual cell contents, that the sum range points to…
- SUMIF Formula Not Working? Fix Common Excel ErrorsIf SUMIF is returning zero or the wrong total, check that its criteria range, criterion, and sum range match the data you…
- SUMIF Function Not Working in Excel? Fix Common ErrorsIf SUMIF is returning zero or the wrong total, first check that the criteria range and sum range cover the intended rows,…
- SUMIF Function Not Working? Fix Common Excel ErrorsIf SUMIF is returning zero, the wrong total, or an error, check that its criteria actually match the cells in the criteria…
- XLOOKUP Spill Error: Why It Happens and How to Fix ItAn XLOOKUP spill error usually means Excel cannot place all the results returned by the formula into the cells it needs. Clear…
- SUMIFS Spill Error: Causes and FixesA SUMIFS spill error usually means Excel is trying to return several results, but something prevents the results from filling the cells…
- Excel #SPILL! Range Isn’t Blank: Causes and FixesIn Excel, “Spill range isn’t blank” means a dynamic-array formula needs to return results into cells that are not empty. Find the…
- Excel Spill Error: Why It Appears and How to Fix ItExcel’s #SPILL! error means a formula is trying to return results into multiple cells, but Excel cannot place the full array in…
- Excel FILTER Spill Error: Causes and FixesA #SPILL! error in an Excel FILTER formula means Excel found results to return but cannot place the full result in the…
- VLOOKUP Spill Error: Common Causes and How to Fix ItA VLOOKUP spill error (#SPILL!) means Excel is trying to return results into multiple cells but cannot place the complete result in…
- Excel Spill Error: What It Means and How to Fix ItExcel’s #SPILL! error means a formula is trying to return multiple results, but Excel cannot place all of them in the cells…