[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.0.1, LO3.6.4, LO4.2.2 on WinXPprof.SP3
Zizi64
Volunteer
 
Posts: 1784
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.0.1, LO3.6.4, LO4.2.2 on WinXPprof.SP3
Zizi64
Volunteer
 
Posts: 1784
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.0.1, LO3.6.4, LO4.2.2 on WinXPprof.SP3
Zizi64
Volunteer
 
Posts: 1784
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: No registered users and 20 guests