I need to know if there is a way to create a formula that will allow me to
enter multiple values in a cell at different times and this formula will sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.

At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me to
enter multiple values in a cell at different times and this formula will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.

And make note of the caveat about having no "audit trail" for error
checking.


Gord Dibben MS Excel MVP

On Wed, 28 Oct 2009 08:27:59 -0700, "Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

OK. This is great- it can be done!

Pretty new at this so what do I do with this code? Copy and paste somewhere?

Thanks!

"Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me to
enter multiple values in a cell at different times and this formula will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.


.

Here you go

http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom


"Brad Grow" wrote in message
...
OK. This is great- it can be done!

Pretty new at this so what do I do with this code? Copy and paste
somewhere?

Thanks!

"Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me
to
enter multiple values in a cell at different times and this formula
will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.


.

OK. Finally got back on this little project and got it to work. Now how can
I make this work for more than one cell on a worksheet? I have played with
it a little bit and I can make it work anywhere on the worksheet, but only
one spot. Also is there any potential problems by having it apply to a range
of cells?

Thank you agaun for your time and assistance.


"Peo Sjoblom" wrote:

Here you go

http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom


"Brad Grow" wrote in message
...
OK. This is great- it can be done!

Pretty new at this so what do I do with this code? Copy and paste
somewhere?

Thanks!

"Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me
to
enter multiple values in a cell at different times and this formula
will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.


.



.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Static dAccumulator As Double
Const WS_RANGE As String = "A1:A10" 'adjust range to suit.
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
If Not IsEmpty(.Value) And IsNumeric(.Value) Then
dAccumulator = dAccumulator + .Value
Else
dAccumulator = 0
End If
Application.EnableEvents = False
.Value = dAccumulator
Application.EnableEvents = True
End With
End If
End Sub

Should pose no problem with a larger range.


Gord Dibben MS Excel MVP

On Mon, 9 Nov 2009 17:48:01 -0800, Brad Grow
wrote:

OK. Finally got back on this little project and got it to work. Now how can
I make this work for more than one cell on a worksheet? I have played with
it a little bit and I can make it work anywhere on the worksheet, but only
one spot. Also is there any potential problems by having it apply to a range
of cells?

Thank you agaun for your time and assistance.


"Peo Sjoblom" wrote:

Here you go

http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom


"Brad Grow" wrote in message
...
OK. This is great- it can be done!

Pretty new at this so what do I do with this code? Copy and paste
somewhere?

Thanks!

"Peo Sjoblom" wrote:

At the bottom there is a formula solution turning on iterations

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

--


Regards,


Peo Sjoblom


"Brad Grow" <Brad wrote in message
...
I need to know if there is a way to create a formula that will allow me
to
enter multiple values in a cell at different times and this formula
will
sum
there values.
Example:
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.

Is this possible and how would it be done?

Thanks for your help.


.



.