Wrong SUM calculated

[excelos]

Hello,

I have some formulas in some cells that display 0. When I SUM these cells it displays 1241.
Also, in some other instance, the sum is VALUE when I only see numbers in these cells.

Can you tell me please what the problem is?

 

[SpillerBD]

Most likely have some Text in there.

 

[RoryA]

SUM ignores text. Either you have a #VALUE error in the sum range (Perhaps a hidden row/column) or this relates to your question about circular references.