[Solved] How to Total a Column

Discuss the spreadsheet application
Post Reply
Sheri_Lynn
Posts: 4
Joined: Thu Jul 07, 2011 5:20 pm

[Solved] How to Total a Column

Post 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!
Last edited by Hagar Delest on Thu Jul 07, 2011 9:29 pm, edited 1 time in total.
Reason: tagged [Solved].
Open Office 3.3 on Windows 7
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to Total a Column

Post 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?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Sheri_Lynn
Posts: 4
Joined: Thu Jul 07, 2011 5:20 pm

Re: How to Total a Column

Post by Sheri_Lynn »

Either/or. I just want to be able to do this without putting in a formula.

Thanks for help!
Open Office 3.3 on Windows 7
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to Total a Column

Post 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
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Sheri_Lynn
Posts: 4
Joined: Thu Jul 07, 2011 5:20 pm

Re: How to Total a Column

Post 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!
Open Office 3.3 on Windows 7
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to Total a Column

Post by Zizi64 »

Check the "View" - "Toolbars" - "Formula bar" if you switched it off, accidentally...
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Sheri_Lynn
Posts: 4
Joined: Thu Jul 07, 2011 5:20 pm

Re: [Solved] How to Total a Column

Post by Sheri_Lynn »

That's exactly what happened--thanks again!
Open Office 3.3 on Windows 7
janka
Posts: 2
Joined: Thu Jun 29, 2017 11:50 am

Re: [Solved] How to Total a Column

Post by janka »

How to sum if you have special values like
12,34 km
23,45 km
....
SUM(A1:Ax)
OpenOffice 3.1 on Windows
janka
Posts: 2
Joined: Thu Jun 29, 2017 11:50 am

Re: [Solved] How to Total a Column

Post by janka »

Solved by myself. There was some paste problem, that's why it didn't do it first time.
OpenOffice 3.1 on Windows
wizardkc
Posts: 3
Joined: Wed Sep 20, 2017 2:21 pm

Re: [Solved] How to Total a Column

Post 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
OpenOffice 5.1.6.2 on Linux Mint 18.1
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] How to Total a Column

Post 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
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply