Thread: Running Totals
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Running Totals

With
A list of values in Col_A, beginning in A1

This formula calculates the running total
B1: =SUM($A$1:A1)

Copy that formula down as far as needed

Note: the Dollar Signs ($) in the formula locks the parts of the reference
that they preceed.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"MAC Man" wrote:

My Question is how to run a total on the next column from values from
preceeding Column EX:

Column A Column B
1 1
2 3
3 6
4 10
5 15