Running Totals
This is exactly what I was looking for Ron. Thanks. The only thing I'd like
to improve is to not have all the following cells down the column = the last
total. Is there a way to have it equal 0 until you enter a new value in the
next cell in Columb A?
"Ron Coderre" wrote:
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
|