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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 1,185 times

Last updated: Jul 02 '18