#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and …

This topic provides help for the most common scenarios for the #VALUE! error in the IF function.

This topic provides help for the most common scenarios for the #VALUE! error in the SUMIF/SUMIFS functions.

This topic provides help for the most common scenarios for the #VALUE! error in the AVERAGE or SUM functions.

The #REF! error shows when a formula refers to a cell that's not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.

Jun 22, 2000 · This topic provides help for the most common scenarios for the #VALUE! error in the DAYS function.

If you're still needing help fixing this error, the following checklist provides troubleshooting steps to help you figure out what may have gone wrong in your formulas.

Jun 22, 2000 · This topic provides help for the most common scenarios for the #VALUE! error in the DATEVALUE function.

This topic explains the common scenarios where you encounter the #VALUE! error when using INDEX and MATCH functions together in a formula.

But the values are in ascending order, and that causes the #N/A error. SOLUTION: Either change the match_type argument to 1, or sort the table in descending format.