Sum does not give the correct answer part of the time

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.

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