A common source of errors in Excel is "the gap"—a situation where you add new data to the bottom of a list, but your formulas ...
Stop manually inserting rows and columns—use Excel's "secret" right-click-drag menu to move, swap, and convert data instantly ...
If Excel is not recognizing functions after reboot, change calculation settings, disable Show Formula, run Excel ...