Ask Your Question

Trying to add columns of numbers in calc using = sum and get either

asked 2021-01-11 22:50:55 +0100

KLOEESDAD gravatar image

The question pretty well states my problem and the details.

edit retag flag offensive close merge delete



Well, I don't understand your "question". Have you checked the documentation to see exactly how =SUM() actually works? And maybe you should give us a working example of the problem. Please EDIT your question to provide any additional information.

ve3oat gravatar imageve3oat ( 2021-01-11 22:55:28 +0100 )edit

You haven't written a question or even a complete sentence, "either" what?

Click in the cell below you column, click the Σ, select Sum from the list, check that the numbers you want added are surrounded by the blue line and press Enter. More on Sum function in Help

Earnest Al gravatar imageEarnest Al ( 2021-01-11 22:59:19 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2021-01-12 00:43:39 +0100

Earnest Al gravatar image

The title is a short reference (limited number of characters) to the subject of the body which contains the actual question. This applies to all written work, e.g. newspapers


image description

Or with the above picture as a reference, using the keyboard, select cell C7 and type =sum(C2:C6), press Enter. The lowercase sum will turn to uppercase in the Input Bar at the top, the cell C7 will display the result (290).

If you don't get a result then check that your numbers are numbers and not text. If you click on, for example, cell C2 and it displays in the Input Bar '56 then it is being read as text. Deleting the apostrophe will allow it to be interpreted as a number. Selecting the cells and then clicking Data > Text to Columns should also remove the apostrophes.

edit flag offensive delete link more

answered 2021-01-12 00:09:19 +0100

KLOEESDAD gravatar image

Obviously my question was too long to be transmited, but I didn't know that.

I got a reply to use the sigma symbol to add the columns, just lke in Excel, but I cannot find the symbol. Can you tell me where it is located?

P.S. One of my three favorite cities in the world is Queenstown, New Zealand.

edit flag offensive delete link more



Please do not use Add Answer if you actually don't answer a question but commenting an answer or responding to another user’s comment. Please use add a comment for that purpose. Thanks in advance …

Opaque gravatar imageOpaque ( 2021-01-12 00:35:16 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-01-11 22:50:55 +0100

Seen: 42 times

Last updated: Jan 12