# OBJECTIVE : automated cumulative sum (1 Viewer)

#### giovanni9720

##### New member
OBJECTIVE : automated cumulative sum

.

.

Hi all, I would like to get the same values contained in column a, but using a formula array so that I don’t have to drag the formula every time, I tried with rif row and row but failed, can anyone help me?

.

A2 contains sum b2 b

A3 contain sum b3 b and so on

View the picture below thanks

#### Attachments

• 0.png
53.3 KB · Views: 23
• 1.png
59.6 KB · Views: 27

#### arnelgp

##### ..forever waiting... waiting for jellybean!
the formula on A2 should be (and copied downward):
Code:
``=SUM(\$B2:\$B\$7)``

#### giovanni9720

##### New member
the formula on A2 should be (and copied downward):
Code:
``=SUM(\$B2:\$B\$7)``
I would like a formula that i dont Need to drag each time, Sum b2 b7 Is not the solution i am looking for, thanks anyway for your time :

#### arnelgp

##### ..forever waiting... waiting for jellybean!
Is not the solution i am looking for, thanks anyway for your time
if you know how Excel work, then you will find same with Google sheet.
you can "double click" on the "dot" and the formula will fill-down.

#### arnelgp

##### ..forever waiting... waiting for jellybean!
also you can try to put the formula i provided on Cell A2.
then to create a "spill" effect, click on cell A2 and hold Shift-Ctrl, then press Enter key (while still holding Shf-Ctrl keys).

Last edited:

#### giovanni9720

##### New member
the formula on A2 should be (and copied downward):
Code:
``=SUM(\$B2:\$B\$7)``
also you can try to put the formula i provided on Cell A2.
then to create a "spill" effect, click on cell A2 and hold Shift-Ctrl, then press Enter key (while still holding Shf-Ctrl keys).
Still is not what i need , i would like to create the formula and dont touch it any more , with methods you show me each day i should drag the formula, i need an array formula that fills all the column automatically, more or less like "=arrayformula(if a2 a <>"", sum b2 b , "")

But i cant use it because i need a different result in a2 , in a3 as so on

I Need the exactly same result of the column A but i dont want to drag the formula

Thanks

Replies
7
Views
506
Replies
4
Views
356
Replies
14
Views
627
Replies
15
Views
975
Replies
4
Views
517