Excel math formula

[Guest]

I have a problem adding a new number to one cell

then that number gets added to a current number (like a running total) in
another cell

then the new added amount shows in that cell?

Trying to update reports...any assistance is appreciative...
V/r

 

[Carim]

Hi Dan,

With you data stored in column A, just type in cell B1 :
=SUM($A$1:A1)
and copy formula all the way down ...


HTH
Carim

 

[Roger Govier]

Hi Carim

This method can be very expensive on processing time as pointed out by
David McRitchie in the following thread
http://snipurl.com/10r17
Might be better to enter in B1 =A1 and in B2 = B1+A2 and copy down
column B

 

[Carim]

Hi Roger,

Thanks Roger for pointing out this issue.
I was not aware of this potential problem ...

Regards
Carim

 

[Gord Dibben]

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 Tools>Options>Calculation 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 Edit>Enter.

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

I have a problem adding a new number to one cell

then that number gets added to a current number (like a running total) in
another cell

then the new added amount shows in that cell?

Trying to update reports...any assistance is appreciative...
V/r

Gord Dibben MS Excel MVP