Ask Your Question

Where is sigma symbol located

asked 2021-01-13 13:18:01 +0100

KLOEESDAD gravatar image

I want to add numbers in columns. I have tried =sum and get #### or err509. Someone indicated I should use the sigme symbol, but I can't find it. Can you tell me where to find it?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2021-01-13 13:29:34 +0100

Opaque gravatar image

updated 2021-01-13 13:32:40 +0100


carefully read the answer to your question

  1. Σ (Sigma) is left of the formula bar
  2. ### indicates that you need to change the column width (LibreOffice Help - Error Codes in LibreOffice Calc)

Here an animated GIF showing both of your issues:

image description

edit flag offensive delete link more


indicates that you need to change the column width

Not necessarily. Sometimes, it is enough to zoom in.

gabix gravatar imagegabix ( 2021-01-13 13:49:14 +0100 )edit

... That's high level nitpicking about zoom being not a congruent transformation with respect to fonts and cell dimensions (font size / cell dimension - ratio is not preserved on zoom)

Opaque gravatar imageOpaque ( 2021-01-13 14:07:59 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-01-13 13:18:01 +0100

Seen: 16 times

Last updated: Jan 13