Ask Your Question

FORMAt for sum function

asked 2018-10-03 23:40:11 +0200

lizcat1 gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-04 03:19:30 +0200

ve3oat gravatar image

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!

edit flag offensive delete link more


If this answers your question, please click on the check mark at left, so that others will know your question was answered.

ve3oat gravatar imageve3oat ( 2018-10-04 06:04:29 +0200 )edit

It's difficult when this is so different from Excel in summing and yet so similar in most other functions.

BigMamaH gravatar imageBigMamaH ( 2018-11-12 08:03:49 +0200 )edit

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.

ve3oat gravatar imageve3oat ( 2018-11-14 04:17:49 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 58 times

Last updated: Oct 04 '18