make cumulative total

[help needed yes please]

Frank here. Can anyone help me work out how to: A1 to A60 are numeric. I want Column 'B' to make a progressive descending total of Column 'A' figures. New at this so yes help would be great, Thanks, F PS: What does it mean when it says here something about 'Tags"?

 

[help needed yes please]

Frank: Thanks to all. Post 6 i said how Aladin put me right in post 4. I cant help but to say THANK YOU to each and every one of you who have so magnificently come on board to help me. I guess i could live with it if someone was able to tell me what the formula in post 4 actually means to excel? Thanks. Be kind to each other have a nice day. F

 

[Aladin Akyurek]

Frank: Thanks to all. Post 6 i said how Aladin put me right in post 4. I cant help but to say THANK YOU to each and every one of you who have so magnificently come on board to help me. I guess i could live with it if someone was able to tell me what the formula in post 4 actually means to excel? Thanks. Be kind to each other have a nice day. F

Post #2 gives you a descending cumulative view (in line with your "make a progressive descending total"), post #4 ascending.

 

[Marcelo Branco]

Frank: Thanks to all. Post 6 i said how Aladin put me right in post 4. I cant help but to say THANK YOU to each and every one of you who have so magnificently come on board to help me. I guess i could live with it if someone was able to tell me what the formula in post 4 actually means to excel? Thanks. Be kind to each other have a nice day. F

The formula in post 4
=SUM(A$1:A1)
does what you've asked in post 3

Hi Aladdin, Frank here; Did as suggested B1 gave answer of 7038 A1 actual 201, A2 541, A3 695. Should give running total of B1 201, B2 742, B3 1437 etc.

M.

 

[help needed yes please]

Hi, ask2. bit slow here but i see you have a cumulative reducing column. Could you give me the formula needed to put into B1. I tried to work it but failed. Could you also give formula for the answer to be in a single cell like the one given before =LARGE(INDEX(SUBTOTAL(9,OFFSET($A$1,0,0,ROW($A$1:$A$60)-ROW($A$1)+1)),0),ROWS($A$1:A1))

 

[help needed yes please]

Frank here. Belated thanks for the explanation. To busy there to let that sink in. Champeon stuff ta, f