[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; AOO4.1.1; LO4.2.8; LO5.0.0 and many Portable LO versions on Win7x64Prof, WinXPprof.SP3x86
User avatar
Zizi64
Volunteer
 
Posts: 2907
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; AOO4.1.1; LO4.2.8; LO5.0.0 and many Portable LO versions on Win7x64Prof, WinXPprof.SP3x86
User avatar
Zizi64
Volunteer
 
Posts: 2907
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; AOO4.1.1; LO4.2.8; LO5.0.0 and many Portable LO versions on Win7x64Prof, WinXPprof.SP3x86
User avatar
Zizi64
Volunteer
 
Posts: 2907
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


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 44 guests