In the video below, I first add a row and write an (integer) value into a number column and then I update the value in the just added column:

Numbers are processed as numbers: they are right-aligned, they are summed - both demonstrated in the video. Though I must admit, after writing the initial value, I had to refresh the page once for SeaTable to calculate the column sum.
Could you simply redo the exercise I have done yourself? You’ll come to the same conclusion.