Thread: progressive sum
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
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