Page 1 of 1

[Solved] How to add figures

PostPosted: Tue May 11, 2021 11:57 pm
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.

Re: Complete Noob! How to add figures

PostPosted: Wed May 12, 2021 12:10 am
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   Expand viewCollapse view
=SUM(M2:M20)

if the numbers are in column M in rows 2 through 20.

Re: Complete Noob! How to add figures

PostPosted: Wed May 12, 2021 12:19 am
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.

Re: Complete Noob! How to add figures

PostPosted: Wed May 12, 2021 12:22 am
by elishasrequest
OK... found "SUM" in "functions"... I found the instructions how to add in the range numbers... problem solved. Thank you.

Re: Complete Noob! How to add figures

PostPosted: Wed May 12, 2021 1:09 am
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.
oo_sum_icon.png
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.