Sum function returns zero [closed]

Question

I keep getting 0 when summing cells in a column in my Google Spreadsheet:

I have verified that the format for both columns are Number:

If I skip the decimal it works fine:

Works fine in MS Excel:

What is going on?

Answer 1

You have a , (comma) as a delimiter while the spreadsheet expects a .(dot)

Mine works with a comma because my language uses a comma as a delimiter.

As you see, my Format -> Number -> Number is different from yours