Page 1 of 1

[Solved] How to Total a Column

Posted: Thu Jul 07, 2011 5:24 pm
by Sheri_Lynn
Can I highlight a column and total it (like in MS Spreadsheet) with a calc button or do I have to manually enter a formula?

Thanks for help!

Re: How to Total a Column

Posted: Thu Jul 07, 2011 6:34 pm
by Zizi64
Hi,

Do you mean: how to Sum all of the rows in a column (for example: the A1:A1048576 cellrange) with a few click??
Or you mean a manually selected (highlighted) cellrange?

Re: How to Total a Column

Posted: Thu Jul 07, 2011 6:54 pm
by Sheri_Lynn
Either/or. I just want to be able to do this without putting in a formula.

Thanks for help!

Re: How to Total a Column

Posted: Thu Jul 07, 2011 7:31 pm
by Zizi64
If you want to sum a manually selected (highlighted) cellrange:

1. Click on target cell
2. click on SUM icon on the toolbar,
3. highlight the desired cellrangerange with mouse,
4. hit Enter.
SUMicon.png

Re: How to Total a Column

Posted: Thu Jul 07, 2011 8:14 pm
by Sheri_Lynn
My problem was that I couldn't find the formula bar. Everything is working great now. Thanks so much for your help!

Re: How to Total a Column

Posted: Thu Jul 07, 2011 9:28 pm
by Zizi64
Check the "View" - "Toolbars" - "Formula bar" if you switched it off, accidentally...

Re: [Solved] How to Total a Column

Posted: Thu Jul 07, 2011 9:34 pm
by Sheri_Lynn
That's exactly what happened--thanks again!

Re: [Solved] How to Total a Column

Posted: Thu Jun 29, 2017 11:53 am
by janka
How to sum if you have special values like
12,34 km
23,45 km
....
SUM(A1:Ax)

Re: [Solved] How to Total a Column

Posted: Thu Jun 29, 2017 6:14 pm
by janka
Solved by myself. There was some paste problem, that's why it didn't do it first time.

Re: [Solved] How to Total a Column

Posted: Mon Mar 25, 2019 1:47 am
by wizardkc
My silly oversight :lol: Column of numbers would not sum.
After several minutes, too many, I realized that even the column showed the numbers as $24.00, they were actually text.
Looking at the value of the cell, is was displayed as '$24.00. Notice the ' before the value, if you have not been bitten by this yet :) .
This can happen when you import data from the web.
Here is a fix i copped and keep handy:

Apply any number format other than "@" (text)
menu:Find&Replace...
[More Options...]
[X] Current Selection
[X] Regular expression
Search: .+ (a dot and a plus)
Replace: &
[Replace All]

Hope this helps

Re: [Solved] How to Total a Column

Posted: Mon Mar 25, 2019 2:00 am
by Villeroy
wizardkc wrote:This can happen when you import data from the web.
This only happens when you ignore the import options on the dialog that is shown when pasting.
Bildschirmfoto von 2019-03-25 01-00-55.png