Forum Discussion

Aliza_Alshehri's avatar
Aliza_Alshehri
Copper Contributor
May 19, 2022

Formula =sum(d11:d15)

Hello 

 

I am trying to write a formula to add up all income entered in Boxes 6 to 10. It works good but there is a yellow sign on the left top corrner of the cell

, when I open it it shows options of error.

I could understand where is my fault. 

excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 19, 2022

    Aliza_Alshehri It's not an error. Just a warning, suggesting that something may be wrong. Excel does some automatic error checking and warns you if the formula is different than ones in adjacent cells, or when you refer to empty cells etc. What exact message do you get?

     

    Many people find it useful to get this kind of warnings. I don't, and have switch of the automatic error checking.