Forum Discussion

MeganGZ's avatar
MeganGZ
Copper Contributor
Apr 25, 2023

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?

excel
Formulas and Functions

1 Reply

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 25, 2023

    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.

Resources