Ask Your Question

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

asked 2018-02-28 02:42:01 +0200

tee gravatar image

updated 2018-02-28 02:48:21 +0200

sum feature in spreadsheet not showing total

edit retag flag offensive close merge delete



try if you make the cell wider.

librebel gravatar imagelibrebel ( 2018-02-28 03:06:49 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-02-28 12:51:33 +0200

ChristopherThomas gravatar image

Increase the column width

edit flag offensive delete link more

answered 2018-03-07 16:57:01 +0200

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.

edit flag offensive delete link more



Toggle display of formulas to get the result.

floris v gravatar imagefloris v ( 2018-03-07 20:34:47 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-28 02:42:01 +0200

Seen: 69 times

Last updated: Mar 07 '18