OBJECTIVE : automated cumulative sum (1 Viewer)

giovanni9720

New member
Local time
Today, 17:03
Joined
Sep 16, 2022
Messages
11
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
    0.png
    53.3 KB · Views: 23
  • 1.png
    1.png
    59.6 KB · Views: 27

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:03
Joined
May 7, 2009
Messages
19,246
the formula on A2 should be (and copied downward):
Code:
=SUM($B2:$B$7)
 

giovanni9720

New member
Local time
Today, 17:03
Joined
Sep 16, 2022
Messages
11
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!
Local time
Today, 23:03
Joined
May 7, 2009
Messages
19,246
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.
dbl_click.jpg
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:03
Joined
May 7, 2009
Messages
19,246
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
Local time
Today, 17:03
Joined
Sep 16, 2022
Messages
11
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
 

Users who are viewing this thread

Top Bottom