I know I can find the sum of a column by entering “=D1+D2+d3…” but there’s got to be a shorter way and I don’t remember it. Please help.
Sorry, I tried this before i submitted the question. It does not add the column.
If it doesn’t then the cell content may be text instead of numbers, see this FAQ.
The column was Currency. I changed it to Number, removed the currency symbol, aligned the figures, and then copied to a new page. The numbers do not add, I simply get the first number in the column. Grantier’s example has a space after SUM and before the ( and another space before the : and I tried the formula with this spacing and with no spacing. It still does not add.
There is no space between SUM and ( above… anyway, spaces are cosmetic and don’t affect the formula.
Your numbers still not adding indicates the cell content really is of type Text instead Numeric. Please follow the procedure given in the FAQ above. Just changing the number display format and aligning content does not re-enter values. The values have to be re-entered after the number format was changed to something different than Text. Copying cells does not change anything.
I don’t know if anyone figured this out yet, or if anyone else has had this problem, but I did. The way I fixed it was to copy the block of numbers, and then ‘paste special’ back into the same block of numbers. Not sure what happened, I tried to reformat the column, then the specific cells, to number, but LibreCalc still refused to sum the numbers. Anyway, ‘paste special’ did the trick.
I needed values in Column F to display a “running total” of all values from a fixed upper cell in E (i.e. the start date) down to the current row which represents the current date (i.e. a new row of data is added each day).
At first I thought this was a simple matter of summing all values in E… for which Grantier’s answer works well. However, in keeping with the spirit of maintaining a running total, I realized what I really needed was a sum of the current day’s value in E with the previous day’s value from one row higher in F.
For that I used “=SUM(F4+E5)” in the F5 cell and then used the “fill handle” in the bottom right corner of F5 to drag that formula down column F as far as needed.
Either way seems to work. I think the second method is more appropriate for my task at hand. Thanks for helping me with this! Most of my spreadsheet work was done over 20 years ago in the mid-1990s so I’m a bit rusty. Fortunately, it comes back to me quickly when I try to remember it. Amazing how so little has changed in all this time!
Remove the commas… this seemed to Finally work for me.
Took me forever too to figure out and have wasted lots of time adding each cell.
Maybe you mean Remove the apostrophes…
Select the column, click Data > Text to Columns, make sure that you don’t have as a separator an character that appears in the numbers, and click OK
It could had helped to read the old comments and follow the FAQ I linked years ago…