[Solved] How to Total a Column

Discuss the spreadsheet application

[Solved] How to Total a Column

Postby Sheri_Lynn » Thu Jul 07, 2011 5:24 pm

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
Sheri_Lynn
 
Posts: 4
Joined: Thu Jul 07, 2011 5:20 pm

Re: How to Total a Column

Postby Zizi64 » Thu Jul 07, 2011 6:34 pm

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; LO4.4.7, LO5.3.6 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.2 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 5913
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to Total a Column

Postby Sheri_Lynn » Thu Jul 07, 2011 6:54 pm

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
Sheri_Lynn
 
Posts: 4
Joined: Thu Jul 07, 2011 5:20 pm

Re: How to Total a Column

Postby Zizi64 » Thu Jul 07, 2011 7:31 pm

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; LO4.4.7, LO5.3.6 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.2 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 5913
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to Total a Column

Postby Sheri_Lynn » Thu Jul 07, 2011 8:14 pm

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
Sheri_Lynn
 
Posts: 4
Joined: Thu Jul 07, 2011 5:20 pm

Re: How to Total a Column

Postby Zizi64 » Thu Jul 07, 2011 9:28 pm

Check the "View" - "Toolbars" - "Formula bar" if you switched it off, accidentally...
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.6 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.2 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 5913
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [Solved] How to Total a Column

Postby Sheri_Lynn » Thu Jul 07, 2011 9:34 pm

That's exactly what happened--thanks again!
Open Office 3.3 on Windows 7
Sheri_Lynn
 
Posts: 4
Joined: Thu Jul 07, 2011 5:20 pm

Re: [Solved] How to Total a Column

Postby janka » Thu Jun 29, 2017 11:53 am

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

Postby janka » Thu Jun 29, 2017 6:14 pm

Solved by myself. There was some paste problem, that's why it didn't do it first time.
OpenOffice 3.1 on Windows
janka
 
Posts: 2
Joined: Thu Jun 29, 2017 11:50 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 46 guests