Why does the sum feature in spreadsheet only show ### for total

sum feature in spreadsheet not showing total

try if you make the cell wider.

Increase the column width

The sum function does not work it only shows the formula in the column or #####. Just to double check myself, I even read the manual to make sure I did it right since this is a variation of Excel. I had to forward a document from one computer to the one with Excel for a summation. =sum(#:#) where # is your data, does not compute. Even if you hand enter all the numbers the old fashioned way with =#+#+#. Nada. But the exact same function in Excel worked in seconds. Seems to be a problem with the function.

Toggle display of formulas to get the result.

Press ctrl+` or uncheck “Show Formula” option under View menu.