Ask Your Question

I want to use the SUM= command to auto update cells incrementally. [closed]

asked 2018-12-07 20:44:58 +0200

robotics1949 gravatar image

updated 2018-12-08 01:15:05 +0200

Thank you for being here to help me. I want to use the SUM= command to auto update cells incrementally. If that is NOT the command I should be using, please advise. Here's 3 images of the ss:

In the "Miles" col formula, I calc product with Steps (B) and (H) Stride in inches and divide by foot then feet per mile. image description

In the Totals section i'm using Sum to count from cell 3 to cells in the col. This output is then added to the running total cell.
image description

This means that every time I walk and enter the data in each cell in each row, I manually have to change the "Totals" cell's latest cell #, ie. B3:B53 and change it to B3:B54. image description

My question: is there an easy way to make the formula auto-calc the next cells data entry and increment update it automatically for me, so all need do is update the latest cell row with the new data? Am I explaining this properly? I think there must be a simple way to do this, but I just can't think of it on my own. I have been through the Help Guide & the Tools re: any "Auto" command; but none of them seem to work the way I need them to. What am I doing wrong? I apologize if I'm overlooking a simple step in creating what I want this Calc Sheet to do.

I'm using LibreOffice Version: Build ID: 1:6.0.6-0ubuntu0.18.04.1 CPU threads: 2; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: group

Thank you very much for your help.

best, ~Robotics1949

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-12-08 17:03:08.415276

2 Answers

Sort by » oldest newest most voted

answered 2018-12-07 21:07:14 +0200

JohnSUN gravatar image

Please try this variant of formula

edit flag offensive delete link more


Ok. thank you. I'm assuming you mean just use the SUM=(B:B) and leave out numbers fr both, correct? If so thank you! I'll try it, and check back.

robotics1949 gravatar imagerobotics1949 ( 2018-12-07 22:32:36 +0200 )edit

No, he meant what he said. Functions always start with an = sign.

ve3oat gravatar imageve3oat ( 2018-12-07 23:01:36 +0200 )edit

YES! It works! Thank you. I knew it was something simple, but couldn't remember. best, ~Robotics1949

robotics1949 gravatar imagerobotics1949 ( 2018-12-08 01:06:57 +0200 )edit

Yes, I realized that, @ve3oat. =Sum(B:B) is the correct syntax. I hurriedly typed it in the comment wrong.. It's all good. Thanks.

robotics1949 gravatar imagerobotics1949 ( 2018-12-08 01:10:01 +0200 )edit

answered 2018-12-08 01:56:26 +0200

jsgaston gravatar image

1st: the formula are written in calc like that = forumula() ..... 2nd: the formula should me the arithmetic sum ((a1+a2+...)/(number of cells)), so you could use this formula =si(a1="";"";1) or something like that (I use the spanish version, so if you use the english one, I supose the formula is =if(...) ; the formula uses an if statement, if the condition a1 (for cell a1) is equal to nothing (""), then you put nothing, and if not you put a 1 ...... (I cant remember if it will work with " " or "" ... just try...) ... so, when you have all those cells with ones... in the total formula, you can now divide by the sum of all the cells in that colum (sum(a1:a999)) (that will sum the cells from a1 to a999) ... so if I was you... I would first do two cells, one adding all the ones (so that you can divide in the averige) and one adding all the data you whant (for example number of steps ...) and in another cell you just divide one cell by the other cell ... and that is how you dont have to keep on changing that formula... I hope I explained clearly

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-12-07 20:44:58 +0200

Seen: 271 times

Last updated: Dec 08 '18