Simple formulas from Excel 2013 do not work in Office 365 excel

So I bough the O365 personal edition and opened my Excel document, originally created in Excel 2013 and to my surprise, even adding a new cell and changing the formula on the "sum" cell, it did not t...