[Solved] How to Total a Column

by **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!

by **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?

by **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!

by **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.

by **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!

by **Zizi64** » Thu Jul 07, 2011 9:28 pm

Check the "View" - "Toolbars" - "Formula bar" if you switched it off, accidentally...

by **Sheri_Lynn** » Thu Jul 07, 2011 9:34 pm

That's exactly what happened--thanks again!

[Solved] How to Total a Column

[Solved] How to Total a Column

Re: How to Total a Column

Re: How to Total a Column

Re: How to Total a Column

Re: How to Total a Column

Re: How to Total a Column

Re: [Solved] How to Total a Column

Who is online