Sum does not give the correct answer part of the time

[Deskjocky]

for example line B23 sum of B1 through B22. The correct answer might be 201 But instead it shows 175. Almost like it skips some the lines.

[mariosv]

Please verify that those skipped values weren’t introduced as text? Ctrl+F8 can help.