Ask Your Question

How can I sum a column or row of numbers in Calc

asked 2018-07-02 20:24:31 +0200

LarryM gravatar image

I've downloaded the "Math Guide version 4.4" so I could learn how to add columns and rows as in this Excel example "@sum(B10:B32)". Unfortunately, the guide reads like Greek and I can't read Greek. Is there a simpler version?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-07-02 21:10:51 +0200

Jim K gravatar image

updated 2018-07-02 21:24:18 +0200

The Math Guide is for the Math Formula editor, which is different from a Calc spreadsheet. The appropriate document is the Calc Guide. See also Getting Started.

However, I looked through these documents, and they do not give a simple answer to your question. Instead of such packaged guides, I normally do a Google search. In this case, the online help is useful.

Here is a simple example.

  1. In cells A1 and B1, enter 40 and 2 respectively.
  2. Select A1 and B1 and press the Sum toolbar icon. Or, in cell C1, enter =SUM(A1:B1).
edit flag offensive delete link more


What does the Sum toolbar icon look like?

LarryM gravatar imageLarryM ( 2019-08-05 21:12:18 +0200 )edit

the Icon for SUM doesn't exist on my 2 tool bars

LarryM gravatar imageLarryM ( 2019-08-05 21:19:53 +0200 )edit

It's part of the main formula bar. Perhaps you unchecked View -> Formula Bar.

Jim K gravatar imageJim K ( 2019-09-19 21:13:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-02 20:24:31 +0200

Seen: 9,191 times

Last updated: Jul 02 '18