[Solved] Column summation icon

Discuss the spreadsheet application

[Solved] Column summation icon

Postby delsur » Tue Nov 07, 2017 2:13 am

Sorry in advance that I don't know the right words to describe what I want

In Calc, above the spreadsheet I have three rows of what I'll call functions
The top says File Edit View ...
Next one has icons for New Open Save ...
The next has an icon for 'styles and formatting', the word Arial in a white box....

Please, what are those rows called and how can I change them? (I think I might be able to get them to disappear but I know I wouldn't be able to figure out how to get them back.)

Years ago, on one of those rows I had the Greek letter sigma?? (looks a bit like an E) and I could click on that and then somehow magically get the numbers in a column added up.
It could be I highlighted the numbers I wanted added before clicking the the 'sigma' sign. I also don't recall how it was determined which cell got the total. I just remember I had to make sure I'd left space for it?

This seems to me a very basic function for a spreadsheet but I can never find it.
Please help me find it and put it some place prominent on all my spreadsheets.

Thanks.

Opened a spreadsheet again after reading Mr. Programmer's response and I suddenly saw Sigma in plain sight right above the A B C column markings. Thanks for helping me see what was right in front of me! Next time I can't find it, I'll come back to this post. ;)
Last edited by delsur on Tue Nov 07, 2017 10:09 pm, edited 1 time in total.
Open Office 4.1.4
Windows 7 Home Premium
delsur
 
Posts: 3
Joined: Tue Nov 07, 2017 1:55 am

Re: Column summation icon

Postby RusselB » Tue Nov 07, 2017 5:01 am

The row at the top (File, Edit, View, etc.) is a menu system. The rows below that with the icons are Toolbars.
The Toolbars are editable by right clicking on the toolbar, but not on an actual icon, and selecting Customize toolbar.

As the the Sigma (which is the correct term), I don't know where it is, as I can't find it on my system, yet several people have made posts regarding the usage of it, so they do have it.
The usage for working with the Sigma, to my understanding, is to highlight the cells you wanted to sum, press the Sigma and the result would go into the next cell on the row (if highlighting a row) or column (for column highlight)

Again, this is based on my understanding of how it works, not based on my own experience, as I don't have the character (nor do I think I would use it, if I did have it)
OpenOffice 4.1.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4113
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Column summation icon

Postby MrProgrammer » Tue Nov 07, 2017 6:32 am

delsur wrote:Years ago, on one of those rows I had the Greek letter sigma?? … Please help me find it and put it some place prominent on all my spreadsheets.
View → Formula Bar

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.9.5.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3111
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Column summation icon

Postby delsur » Tue Nov 07, 2017 9:57 pm

Mr. Programmer, thanks for help with terminology and info on how to edit the toolbars.

Your description of how Sigma works has jogged my memory.

Hopefully someone will come along to tell me where to find Sigma and how to add it to one of my toolbars.
Open Office 4.1.4
Windows 7 Home Premium
delsur
 
Posts: 3
Joined: Tue Nov 07, 2017 1:55 am

Re: Column summation icon

Postby RoryOF » Tue Nov 07, 2017 10:01 pm

In Calc turn on /View /Formula Bar. I've never seen it in Writer.
Apache OpenOffice 4.1.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25378
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: SOLVED Column summation icon

Postby delsur » Tue Nov 07, 2017 10:12 pm

Thanks, RoryOF!

I see it now.
Open Office 4.1.4
Windows 7 Home Premium
delsur
 
Posts: 3
Joined: Tue Nov 07, 2017 1:55 am


Return to Calc

Who is online

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