[Solved] How to add figures

Discuss the spreadsheet application
Post Reply
elishasrequest
Posts: 3
Joined: Tue May 11, 2021 11:54 pm

[Solved] How to add figures

Post by elishasrequest »

So I made a spread sheet with a column of numbers on the far right. I have no idea how to have all those numbers add up to a total that I can enter at the bottom. I realize I may even be using the wrong terminology... sorry! How do I add up the column of numbers.
Last edited by robleyd on Wed May 12, 2021 1:12 am, edited 1 time in total.
Reason: Tagged [Solved]; add green tick
Mac 10.13, Open Office 4.1.10
FJCC
Moderator
Posts: 8646
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Complete Noob! How to add figures

Post by FJCC »

The easiest way is to click on the cell just below the last number and then click on the Sum icon in the tool bar that is just above the column headers. The Sum icon is an upper case Greek sigma, Σ, and it is probably just above the B column header. After clicking that press the Enter key. The cell will now contain a formula that is something like

Code: Select all

=SUM(M2:M20)
if the numbers are in column M in rows 2 through 20.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
elishasrequest
Posts: 3
Joined: Tue May 11, 2021 11:54 pm

Re: Complete Noob! How to add figures

Post by elishasrequest »

Thanks for your quick reply! I have searched the entire screen and cannot find the "sigma" icon... I took a screen shot, but I don't know if I can post it here.
Mac 10.13, Open Office 4.1.10
elishasrequest
Posts: 3
Joined: Tue May 11, 2021 11:54 pm

Re: Complete Noob! How to add figures

Post by elishasrequest »

OK... found "SUM" in "functions"... I found the instructions how to add in the range numbers... problem solved. Thank you.
Mac 10.13, Open Office 4.1.10
User avatar
robleyd
Moderator
Posts: 4433
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Complete Noob! How to add figures

Post by robleyd »

It is part of the Formula bar as shown in the attached image. It may be that you need to turn on display of the Formula bar using View | Formula Bar.
Click image to enlarge
Click image to enlarge
[Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire and post the link here. Crop images as needed and reduce the colour depth if the image is too big.

As a newcomer to Calc, you may find [Tutorial] Ten concepts that very Calc user should know a useful resource.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 15 - 64 bit
LibreOffice 6.4.6.2 (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 15 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
Post Reply