Ask Your Question

how do i calculate the sum of a row

asked 2018-02-14 00:02:19 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-02-14 01:11:16 +0200

librebel gravatar image

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:


The same result can also be achieved by 4 clicks:

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

HTH, lib

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 2,653 times

Last updated: Feb 14 '18