Ask Your Question

How can I automate adding subtotals in the next column

asked 2020-01-16 09:34:16 +0200

Pankaj2006 gravatar image

updated 2020-08-05 15:08:43 +0200

Alex Kemp gravatar image

Hello, I am trying to add subtotals in the next column. The data is a little large spanning across 10k rows. How can I automate? Pankaj

edit retag flag offensive close merge delete


as i think you don't ask for C100: '=SUM(B10;B20;B30;B100)' it would be helpful to give a more detailed description of your case ...

newbie-02 gravatar imagenewbie-02 ( 2020-07-02 11:01:26 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-07-28 18:31:12 +0200

LeroyG gravatar image

To add a subtotal at each row: If data are in A2:A10000, type in B2 =A2, and in B3 =B2+A3, then copy B3 until B10000.

See sample file: subtotal in next column.ods. Colored cells have formulas.

Edit your question if you need to add more information (Add Answer is reserved for solutions).

Check the mark (Correct answer mark) to the left of the answer that solves your question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-16 09:34:16 +0200

Seen: 50 times

Last updated: Jul 28 '20