# 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 +0100 **

Seen: **1,441 times**

Last updated: **Feb 14 '18**

Paste option right click disappears

Format Range to Number and 2 decimal places

Libreoffice re-type password [closed]

Calc: Reading in text data file, header row not recognized as a header [closed]

Unauthorised Changes Blocked by Defender in Win 10 Why?

formula for running total in calc

Print active sheet in multi sheet spreadsheet

reset autofilter with button? [closed]

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