#REF! Error in Excel – How to Fix the Reference Error
A #REF error is a message that Excel sends when the formula references a cell that is no longer available, maybe because it has been deleted. If you have worked with formulas in Excel, you have likely come across this error. It appears when the formula has no idea where to point to as it