Ask Your Question
0

Auto Sum doesn't work...?

asked 2018-01-15 01:46:01 +0100

EshBoo gravatar image

I have a simple Sum formula (=SUM(E5:E16)) in a spreadsheet but when I'm adding or removing numbers in that given range the Sum number stays the same. Anyone can tell me why?

On a side note, this is my second week of lightly using Calc and I can't say I'm impressed so far...

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2018-01-15 02:36:26 +0100

Ratslinger gravatar image

updated 2018-01-15 02:37:45 +0100

Hello,

Probably AutoCalculate is off. From menu Data->Tools->Calculate click on AutoCalculate (will then have checkmark). F9 will also re-calc sheet.

edit flag offensive delete link more

Comments

1

Also check that the cells in the range aren't formatted as text

Mike Kaganski gravatar imageMike Kaganski ( 2018-01-15 06:02:33 +0100 )edit
-1

answered 2018-01-15 20:13:27 +0100

EshBoo gravatar image

Ok, the fact that you have to "Turn on" the Calculation function on a software that's made for calculations is just sad and ridicules! It's like you told me to "Turn on" the Calculation function on my calculator...

That said, the AutoCalculate was on (check marked) when I went to check, so something else is not working there... Cell are formatted for numbers.

edit flag offensive delete link more

Comments

Ok, the fact that you make jokes without understanding is sad and ridicules. There is a function (disabled by default) to turn calculations off, that is targeted to those who create heavy interlinked spreadsheets that may trigger recalculations on every change, so one could want to turn it off and fill some big amount of data, then turn it on. So those who know about that feature might suspect that one possible cause of your problem is wrong setting of the feature... on which you make laughs

Mike Kaganski gravatar imageMike Kaganski ( 2018-01-15 21:17:21 +0100 )edit

Please do not respond to an answer with another answer - use a comment attached to the answer you are responding to. Answers are to be used for response to original question. You may also edit your original question if you need to add additional information.

Ratslinger gravatar imageRatslinger ( 2018-01-15 21:19:17 +0100 )edit

Please attach a sample here, so that others could check it, and possibly not annoy you anymore with their pathetic attempts to help you without sitting at your keyboard.

Mike Kaganski gravatar imageMike Kaganski ( 2018-01-15 21:19:26 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-15 01:46:01 +0100

Seen: 2,113 times

Last updated: Jan 15 '18