# how do i calculate the sum of a row

Is there an icon i can click on to get the sum of a row?

First time here? Check out the FAQ!

0

Hello @novaone,

Suppose that you want to calculate the sum of Row 1, and put the result into cell A2, then you could enter the following formula into cell A2:

`=SUM(1:1)`

The same result can also be achieved by 4 clicks:

- Click inside your cell A2 to select it;
- Click on the (sigma) Σ button;
- Then click on the Row Header of Row 1;
- Finally click on the green “Accept” button to the left of the input line.

HTH, lib

Asked: ** 2018-02-14 00:02:19 +0200 **

Seen: **2,653 times**

Last updated: **Feb 14 '18**

Need to insert cell data into a text box [closed]

Calc: INDIRECT() function with Column/Row labels

Remove commas from decimal number?

CALC 5.4.2.2 Drop Boxes don't work

CALC - Function SMALL changed since version 6.2 - How now?

[Calc] Error with Concatenate formula

"Reference" Cells for COUNTIF (Calc)

Find values in Column B that are not in column A? [closed]

Protecting a Cell Disables Users to Adjust the Width/Height?

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.