#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default progressive sum

dear sir,
i want the progressive sum of cell values in one column like this
column "a" , "a1"=10,"a2"=15,"a3"=20,"a4"=30 and i want the progressive sum
of column A in column B like this
column "b" , "b1"=10,"b2'=25, "b3"=45 ,"b4"=75 and so on with respect to
column A CELL values
can any kind guy can help me please



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default progressive sum

Try this:

Enter this formula in B1:

=A1

Enter this formula in B2 and copy down as needed:

=B1+A2

Another way if your list of numbers in column A isn't too long:

Enter this formula in B1 and copy down as needed:

=SUM(A$1:A1)


--
Biff
Microsoft Excel MVP


"balu" wrote in message
...
dear sir,
i want the progressive sum of cell values in one column like this
column "a" , "a1"=10,"a2"=15,"a3"=20,"a4"=30 and i want the progressive
sum
of column A in column B like this
column "b" , "b1"=10,"b2'=25, "b3"=45 ,"b4"=75 and so on with respect to
column A CELL values
can any kind guy can help me please





  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default progressive sum

dear sir ,
i would like to represent my need in detail my for mula on an accessform
like this
dim xlbook as excel.workbook
dim xlsheet as excel.worksheet
dim xlapp as excel.application
set xlapp = createobject ( " excel.application")
set xlbook = xlapp.workbook.add
set xlsheet = xlbook.xlsheet(1)
xlapp.visible = true
xlsheet.range("a1").value = 1000
xlsheet.range("b1").value = 200
xlsheet.range("c1").formula = xlsheet.range("a1").value -
xlsheet.range("b1").value
xlsheet.range("c2").formula = xlsheet.range("a2").value -
xlsheet.range("b2").value
'**********************
' actually column A and column b values were query values imported.

xlsheet.range("c1:c2").autofill ( xxlsheet.range("c1"):xlsheet.range("c25"))

' here im failing to autofill the formula for the range through code but
' i can with dragging the curser on the excel sheet on column C why ?
so it must be alike this,
a1=100 a2 = 200 a3 = 300
b1= 10 b2 = 0 c3 = 20
c1 = 110 c2 = 200 c3 = 320


please advise sir



"T. Valko" wrote:

Try this:

Enter this formula in B1:

=A1

Enter this formula in B2 and copy down as needed:

=B1+A2

Another way if your list of numbers in column A isn't too long:

Enter this formula in B1 and copy down as needed:

=SUM(A$1:A1)


--
Biff
Microsoft Excel MVP


"balu" wrote in message
...
dear sir,
i want the progressive sum of cell values in one column like this
column "a" , "a1"=10,"a2"=15,"a3"=20,"a4"=30 and i want the progressive
sum
of column A in column B like this
column "b" , "b1"=10,"b2'=25, "b3"=45 ,"b4"=75 and so on with respect to
column A CELL values
can any kind guy can help me please






  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default progressive sum

I can't help you with this. Maybe try posting in the programming newsgroup.
On thing I did notice is in autofill the double xx in xlsheet:

xlsheet.range("c1:c2").autofill (
xxlsheet.range("c1"):xlsheet.range("c25"))


--
Biff
Microsoft Excel MVP


"balu" wrote in message
...
dear sir ,
i would like to represent my need in detail my for mula on an accessform
like this
dim xlbook as excel.workbook
dim xlsheet as excel.worksheet
dim xlapp as excel.application
set xlapp = createobject ( " excel.application")
set xlbook = xlapp.workbook.add
set xlsheet = xlbook.xlsheet(1)
xlapp.visible = true
xlsheet.range("a1").value = 1000
xlsheet.range("b1").value = 200
xlsheet.range("c1").formula = xlsheet.range("a1").value -
xlsheet.range("b1").value
xlsheet.range("c2").formula = xlsheet.range("a2").value -
xlsheet.range("b2").value
'**********************
' actually column A and column b values were query values imported.

xlsheet.range("c1:c2").autofill (
xxlsheet.range("c1"):xlsheet.range("c25"))

' here im failing to autofill the formula for the range through code but
' i can with dragging the curser on the excel sheet on column C why ?
so it must be alike this,
a1=100 a2 = 200 a3 = 300
b1= 10 b2 = 0 c3 = 20
c1 = 110 c2 = 200 c3 = 320


please advise sir



"T. Valko" wrote:

Try this:

Enter this formula in B1:

=A1

Enter this formula in B2 and copy down as needed:

=B1+A2

Another way if your list of numbers in column A isn't too long:

Enter this formula in B1 and copy down as needed:

=SUM(A$1:A1)


--
Biff
Microsoft Excel MVP


"balu" wrote in message
...
dear sir,
i want the progressive sum of cell values in one column like this
column "a" , "a1"=10,"a2"=15,"a3"=20,"a4"=30 and i want the progressive
sum
of column A in column B like this
column "b" , "b1"=10,"b2'=25, "b3"=45 ,"b4"=75 and so on with respect
to
column A CELL values
can any kind guy can help me please








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Progressive Calculation nospaminlich Excel Worksheet Functions 5 November 1st 05 10:03 AM
Progressive Addition Formula Robert Moore Excel Worksheet Functions 2 July 17th 05 03:52 AM
progressive select Mike Excel Worksheet Functions 1 June 8th 05 02:08 AM
Progressive summing Maarten Excel Worksheet Functions 5 April 27th 05 10:25 AM
Progressive Dating of Columns Shadyhosta New Users to Excel 4 December 29th 04 06:06 AM


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"