Ask Your Question

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

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. 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. 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. 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: 6.0.6.2 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 reopen merge delete

## 2 Answers

Sort by » oldest newest most voted Please try this variant of formula

=SUM(B:B)

more

## Comments

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.

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

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

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.

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

more

## Stats

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

Seen: 100 times

Last updated: Dec 08 '18