Excel Running Total
Posted by john m on June 20, 2001 2:15 PM
How do I keep a running total of a column? I want the function for the running total to be dynamic so that when I insert a row, that row will be included in the running total. Please Help!
Posted by Ben O. on June 20, 2001 2:31 PM
Use =SUM(A:A) for column A, or replace A with whatever column you want a running total for.
-Ben
Posted by Mark W. on June 20, 2001 2:39 PM
Let's say that A1:A10 contains {10;20;30;40;50;60;70;80;90;100}.
You could enter the formula, =SUM(INDIRECT("A1"):OFFSET(B1,0,-1)),
into cell A1 and Copy down to cell A10. Now, keep in mind that
if you add a row you'll still need to copy the formula in column B
down to the newly added cell. Is this what you're after?
Posted by IML on June 20, 2001 2:57 PM
One other take
Lets say you currently have columns data in columns A-C. Put this formula in column e
=SUM($A$1:D1)
and copy it down as far as you need to for a running total.
Now when you add a column highligh D and insert a column and your new column will be in the total
I think I am reading this totally differently and probably incorrectly.
good luck
Posted by Mark W. on June 20, 2001 2:59 PM
Maybe...
I'm reading too much into your request! Please
clarify what you mean by "running total".
Posted by Aladin Akyurek on June 20, 2001 3:09 PM
Re: Maybe...
a simple total tha must be updated?
Aladin
Posted by Mark W. on June 20, 2001 3:15 PM
Re: Maybe...
Well, I think of a running *anything* as a set of
successive values. In fact, Excel's Help topic
for "Examples of common formulas" shows an example
of a running balance that's not unlike my suggestion.
Posted by john m on June 20, 2001 4:22 PM
Re: Maybe...
Yes a simple total that has to be updated
Posted by Mark W. on June 20, 2001 4:25 PM
Then...
...I guess Ben O. got it! Yes a simple total that has to be updated : Well, I think of a running *anything* as a set of
Posted by john m on June 20, 2001 5:22 PM
Yes this works but you cannot place the total then in the same column because it creates a circular reference. Any ideas on that one? P.S. Thanks for your help everyone its really appeciated!
Posted by Mark W. on June 20, 2001 5:34 PM
Use =SUM(INDIRECT("A1"):OFFSET(A5,-1,)) replacing
the 1st OFFSET() argument, A5, with a reference
to the cell where this formula is entered. Yes this works but you cannot place the total then in the same column because it creates a circular reference. Any ideas on that one? P.S. Thanks for your help everyone its really appeciated!
