green arrow at the right upper corner of a cell , error warning : what kind of error is that ?

[Ron Wolpa]

I am working on a very basic spreadsheet and cannot comprehend why I am having the error warning [ ? ! ] Enclosed to this post the image of such error warning .
From row # 4 up to row # 34 I have basic formulas like =C4+D4+E4+F4+G4+H4+I4+J4+K4+L4+M4+N4+O4+P4+Q4+R4+S4+T4+U4+V4+W4+X4+Y4+Z4 - this formula is into cel # AA4 and so on every row up to # AA34 where is =C34+D34+E34+F34.........+Z34.
On row # 35 I have =AA4+AA5+AA6+AA7+AA8+AA9+AA10+AA11+AA12+AA13+AA14+AA15+AA16+AA17+AA18+AA19+AA20+AA21+AA22+AA23+AA24+AA25+AA26+AA27+AA28+AA29+AA30+AA31+AA32+AA33+AA34
, that is the addition of the row results .
What possibly could be wrong ? I do not see any inconsistency on the formulas.
thank you .

 

[Fluff]

What does it say if you click on the !

 

[Ron Wolpa]

What does it say if you click on the ! >>>> as on the enclosed image

 

[Fluff]

Then the you do not have the same formula in every cell in that column.

 

[Ron Wolpa]

As explained I am adding on that column the result of the rows.
I have rechecked the formulas from row # 4 to # 34 and don´t seem to have anything wrong ... I am about to click on ignore error

 

[Fluff]

From row 4 down to 34 you have a formula that is add cells on that row, but on row 35 you have a formula that is adding the column, that is not the same formula.
Also you can change your formula to

=SUM(C4:Z4)

& drag down

 

[Ron Wolpa]

Hello Fluff ,
I am avoiding to employ the autosum =SUM(C4:Z4) because I had similar issues then made up my mind to write the formulas from # row 4 to # 34.
It was a pain but I paid the price to see whether I was going to get rid of such error warning.
I am working on the new 2023 expanses spreadsheet , similar than 2022 expanses spreasheet , on which the error occurs on some cells. I am simply used to click on ignore error and recheck the adding with a calculator. I found that it does not affect the results at all.
But this time , with a new spreadsheet , I would be glad to have it clean.
thank you for your support

 

[Ron Wolpa]

trace precedents seems to reveal a "link" between row 20 and 21.

 

[Fluff]

If you have two completely different formulae on the same column like you have, you will always get that warning.

trace precedents seems to reveal a "link" between row 20 and 21.

That probably means your formula is probably looking at the wrong row, another good reason to use SUM as you are less likely to get typos.

 

[Ron Wolpa]

That probably means your formula is probably looking at the wrong row, ..... that's absolutely right , definitely 'trace precedents' help me to pinpoint my mistake.
Thank you for your help.