[Solved] How to Total a Column
-
- Posts: 4
- Joined: Thu Jul 07, 2011 5:20 pm
[Solved] How to Total a Column
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!
Thanks for help!
Last edited by Hagar Delest on Thu Jul 07, 2011 9:29 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Open Office 3.3 on Windows 7
Re: How to Total a Column
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?
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.
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.
-
- Posts: 4
- Joined: Thu Jul 07, 2011 5:20 pm
Re: How to Total a Column
Either/or. I just want to be able to do this without putting in a formula.
Thanks for help!
Thanks for help!
Open Office 3.3 on Windows 7
Re: How to Total a Column
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.
1. Click on target cell
2. click on SUM icon on the toolbar,
3. highlight the desired cellrangerange with mouse,
4. hit Enter.
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.
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.
-
- Posts: 4
- Joined: Thu Jul 07, 2011 5:20 pm
Re: How to Total a Column
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
Re: How to Total a Column
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.
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.
-
- Posts: 4
- Joined: Thu Jul 07, 2011 5:20 pm
Re: [Solved] How to Total a Column
That's exactly what happened--thanks again!
Open Office 3.3 on Windows 7
Re: [Solved] How to Total a Column
How to sum if you have special values like
12,34 km
23,45 km
....
SUM(A1:Ax)
12,34 km
23,45 km
....
SUM(A1:Ax)
OpenOffice 3.1 on Windows
Re: [Solved] How to Total a Column
Solved by myself. There was some paste problem, that's why it didn't do it first time.
OpenOffice 3.1 on Windows
Re: [Solved] How to Total a Column
My silly oversight 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
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
Re: [Solved] How to Total a Column
This only happens when you ignore the import options on the dialog that is shown when pasting.wizardkc wrote:This can happen when you import data from the web.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice