OBJECTIVE : automated cumulative sum (1 Viewer)

[giovanni9720]

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

 

[arnelgp]

the formula on A2 should be (and copied downward):

=SUM($B2:$B$7)

 

[giovanni9720]

the formula on A2 should be (and copied downward):

=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]

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]

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).

 

[giovanni9720]

the formula on A2 should be (and copied downward):

=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