# FORMAt for sum function

i have done the sum function with too many other spreadsheets and cannot remember hos to do inLO

First time here? Check out the FAQ!

FORMAt for sum function

i have done the sum function with too many other spreadsheets and cannot remember hos to do inLO

add a comment

1

The help files are often very helpful.

One method is to type in the cell where you want the answer "=SUM(" but without the quotation marks, then with your cursor highlight the column of figures you want summed, then hit Enter. Le voila!

Well, there are four different ways to sum a column in LibreOffice that I know of. Perhaps one or several of them are similar to Excel. (I don't have Excel to experiment with.) One that seems to be popular is to highlight the column of figures then to click on the Sum command in the toolbar (letter sigma) and the sum appears in the next empty cell of that column; perhaps that is the method you are thinking of.

Asked: ** 2018-10-03 23:40:11 +0200 **

Seen: **58 times**

Last updated: **Oct 04 '18**

How do you save as MS Office 2013?

Is there a *.xlsx Filter Option? [closed]

LibreOffice Calc - Generating hyperlinks in cells

How to make DATEADD (or equivalent) work in LibreOffice Calc? [closed]

Very long text in one Libre Calc cell. Hide/unhide tool?

How do I right align with an indent in a Calc cell?

Instruction to install libreoffice on Debian GNU/Linux 8

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.