Hi,
In your data numbers are stored in text format so sum function wont work.

use text to Column

1. select the number column
2. go to "Data tab" - "Text to Columns"
3. click Next, Next and Finish

Thanks

Moderator removed promo link