I would like to create a running total that adds on to itself. Is there a
way I can do this...simply, lol? Thanks! Here is an example

mileage on mileage off subtotal total miles
54999 55000 1 I want this number to
add to
itself as I
change the subtotal.
*not a running total that descends down the page, I only get one line per
tire and I need to keep the total miles dynamic within one cell. I can't
figure how to make the sum add to itself.
Hopefully, I was able to explain that correctly. Thanks!

Are you sure you want to do this?

Think about it after reading the following.

You can have a cumulative total in a cell if you have a
separate source cell for adding a new total to the original.

Use at your own risk. I am Posting this just to show you how it can
be done, not as a good solution. You would be much better off to
have another column so you can keep track of past entries.

Goes like this: =IF(CELL("address")="$C$4",C4+D4,D4)

Enter this in cell D4 and then in ToolsOptionsCalculation check
Iterations and set to 1.

Now when you change the number in C4, D4 will accumulate.

Note 1. If C4 is selected and a calculation takes place anywhere in
the Application D4 will update even if no new number is entered in
C4. NOT GOOD.

Note 2. This operation is not recommended because you will have no
"paper trail" to follow. Any mistake in entering a new number in C4
cannot be corrected. NOT GOOD.

To clear out the accumulated total in D4 and start over, select D4
and EditEnter.

Check out Laurent Longre's MoreFunc.xla. Has a Function RECALL
which does what you want without the re-calculation problem, but
again there is no "paper trail" for back-checking in case of errors
in data input.

http://longre.free.fr/english/func_cats.htm

Also see John McGimpsey's site for VBA method.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben Excel MVP

On Wed, 6 Sep 2006 12:43:02 -0700, missoulapoet
wrote:

I would like to create a running total that adds on to itself. Is there a
way I can do this...simply, lol? Thanks! Here is an example

mileage on mileage off subtotal total miles
54999 55000 1 I want this number to
add to
itself as I
change the subtotal.
*not a running total that descends down the page, I only get one line per
tire and I need to keep the total miles dynamic within one cell. I can't
figure how to make the sum add to itself.
Hopefully, I was able to explain that correctly. Thanks!

Gord Dibben MS Excel MVP

I could add another column, but not another row like they show me on the
Excell "help." I have created subtotals of the things I wanted to keep a
total of, but I don't know how to keep the running total without physically
going in and adding it up in the last column. Columns are not a problem,
rows are. Thank you very much for replying.

"Gord Dibben" wrote:

Are you sure you want to do this?

Think about it after reading the following.

You can have a cumulative total in a cell if you have a
separate source cell for adding a new total to the original.

Use at your own risk. I am Posting this just to show you how it can
be done, not as a good solution. You would be much better off to
have another column so you can keep track of past entries.

Goes like this: =IF(CELL("address")="$C$4",C4+D4,D4)

Enter this in cell D4 and then in ToolsOptionsCalculation check
Iterations and set to 1.

Now when you change the number in C4, D4 will accumulate.

Note 1. If C4 is selected and a calculation takes place anywhere in
the Application D4 will update even if no new number is entered in
C4. NOT GOOD.

Note 2. This operation is not recommended because you will have no
"paper trail" to follow. Any mistake in entering a new number in C4
cannot be corrected. NOT GOOD.

To clear out the accumulated total in D4 and start over, select D4
and EditEnter.

Check out Laurent Longre's MoreFunc.xla. Has a Function RECALL
which does what you want without the re-calculation problem, but
again there is no "paper trail" for back-checking in case of errors
in data input.

http://longre.free.fr/english/func_cats.htm

Also see John McGimpsey's site for VBA method.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben Excel MVP

On Wed, 6 Sep 2006 12:43:02 -0700, missoulapoet
wrote:

I would like to create a running total that adds on to itself. Is there a
way I can do this...simply, lol? Thanks! Here is an example

mileage on mileage off subtotal total miles
54999 55000 1 I want this number to
add to
itself as I
change the subtotal.
*not a running total that descends down the page, I only get one line per
tire and I need to keep the total miles dynamic within one cell. I can't
figure how to make the sum add to itself.
Hopefully, I was able to explain that correctly. Thanks!

Gord Dibben MS Excel MVP

I got it to work using one of the links you showed me. Thanks!

"missoulapoet" wrote:

I could add another column, but not another row like they show me on the
Excell "help." I have created subtotals of the things I wanted to keep a
total of, but I don't know how to keep the running total without physically
going in and adding it up in the last column. Columns are not a problem,
rows are. Thank you very much for replying.

"Gord Dibben" wrote:

Are you sure you want to do this?

Think about it after reading the following.

You can have a cumulative total in a cell if you have a
separate source cell for adding a new total to the original.

Use at your own risk. I am Posting this just to show you how it can
be done, not as a good solution. You would be much better off to
have another column so you can keep track of past entries.

Goes like this: =IF(CELL("address")="$C$4",C4+D4,D4)

Enter this in cell D4 and then in ToolsOptionsCalculation check
Iterations and set to 1.

Now when you change the number in C4, D4 will accumulate.

Note 1. If C4 is selected and a calculation takes place anywhere in
the Application D4 will update even if no new number is entered in
C4. NOT GOOD.

Note 2. This operation is not recommended because you will have no
"paper trail" to follow. Any mistake in entering a new number in C4
cannot be corrected. NOT GOOD.

To clear out the accumulated total in D4 and start over, select D4
and EditEnter.

Check out Laurent Longre's MoreFunc.xla. Has a Function RECALL
which does what you want without the re-calculation problem, but
again there is no "paper trail" for back-checking in case of errors
in data input.

http://longre.free.fr/english/func_cats.htm

Also see John McGimpsey's site for VBA method.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben Excel MVP

On Wed, 6 Sep 2006 12:43:02 -0700, missoulapoet
wrote:

I would like to create a running total that adds on to itself. Is there a
way I can do this...simply, lol? Thanks! Here is an example

mileage on mileage off subtotal total miles
54999 55000 1 I want this number to
add to
itself as I
change the subtotal.
*not a running total that descends down the page, I only get one line per
tire and I need to keep the total miles dynamic within one cell. I can't
figure how to make the sum add to itself.
Hopefully, I was able to explain that correctly. Thanks!

Gord Dibben MS Excel MVP