Forum Discussion
Excell Error
I am getting errors on my worksheet that I don't understand. When I click on the exclamation point, it says "Formula omits adjacent cells." What does this mean and how do I correct it?
MeganGZ That's not an error, though a warning where Excel suspects that your formula is wrong.
Let's say you have cells with numbers in range A1:A20. Now enter a SUM formula in A21 like =SUM(A1:A18). Excel will warn you as it suspects that you accidentally left out cells A19 and A20 from the SUM. Up to you to decide if that is the case or not. Fix it if it really is an error or ignore when it is not.