Ask Your Question
0

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
0

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

Opaque gravatar image

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

Hello,

carefully read the answer to your question https://ask.libreoffice.org/en/question/287091/trying-to-add-columns-of-numbers-in-calc-using-sum-and-get-either/.

  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

Comments

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

Stats

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

Seen: 16 times

Last updated: Jan 13