I need a totalizer formula?

example : A number is put daily in A1, then auto transfered to A2
Next day a new number entred in A1 will be
accumulated
in A2.( A2 is considred as accumulator or
integrator)

thanx for help.;)


--
KARIM
------------------------------------------------------------------------
KARIM's Profile: http://www.excelforum.com/member.php...o&userid=29874
View this thread: http://www.excelforum.com/showthread...hreadid=495779

Hi KARIM,

See

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

--
Kind regards,

Niek Otten

"KARIM" wrote in
message ...

I need a totalizer formula?

example : A number is put daily in A1, then auto transfered to A2
Next day a new number entred in A1 will be
accumulated
in A2.( A2 is considred as accumulator or
integrator)

thanx for help.;)


--
KARIM
------------------------------------------------------------------------
KARIM's Profile:
http://www.excelforum.com/member.php...o&userid=29874
View this thread: http://www.excelforum.com/showthread...hreadid=495779

Karim

If you "must" have an accumulator cell, check this thread out before
proceeding.

http://snipurl.com/8e64


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 10:06:47 -0600, KARIM
wrote:


I need a totalizer formula?

example : A number is put daily in A1, then auto transfered to A2
Next day a new number entred in A1 will be
accumulated
in A2.( A2 is considred as accumulator or
integrator)

thanx for help.;)

A useful addition, Gord
I have put it in my notes

Thanks,

--
Kind regards,

Niek Otten

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Karim

If you "must" have an accumulator cell, check this thread out before
proceeding.

http://snipurl.com/8e64


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 10:06:47 -0600, KARIM
wrote:


I need a totalizer formula?

example : A number is put daily in A1, then auto transfered to A2
Next day a new number entred in A1 will be
accumulated
in A2.( A2 is considred as accumulator or
integrator)

thanx for help.;)

Thankx A Lot For Help


--
KARIM
------------------------------------------------------------------------
KARIM's Profile: http://www.excelforum.com/member.php...o&userid=29874
View this thread: http://www.excelforum.com/showthread...hreadid=495779

Thankx A Lot For Help


--
KARIM
------------------------------------------------------------------------
KARIM's Profile: http://www.excelforum.com/member.php...o&userid=29874
View this thread: http://www.excelforum.com/showthread...hreadid=495779

Thanks Nick

"Accumulating" has its place, but not very often and is fraught with peril
when a mistake is made.

I answered one poster with this method and he seemed pleased.

You could use a worksheet_change event macro to enter the contents of the
input cell into column B at the next available empty row.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo stoppit
Application.EnableEvents = False
If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub
With Target
If .Value < "" Then
ActiveSheet.Cells(Rows.Count, "B").End(xlUp) _
.Offset(1, 0).Value = Target.Value
End If
End With
stoppit:
Application.EnableEvents = True
End Sub

Right-click on your sheet tab and select "View Code". Copy the above code
into the module that opens.

I would enter in B1 =Sum(B2:B500). Whatever you think you need
to gather all future values in Column B.

Using A1 as the input cell, any new number entered will be automatically
placed into Column B(starting at B2)at the next available empty row.

Now you have a "paper trail" and a Totalizer cell(B1)

Note: if a mistake is made in last entered number in A1 , you will have to
delete the contents of the last cell in Column B then re-enter in A1.


Gord

On Fri, 23 Dec 2005 19:53:01 +0100, "Niek Otten" wrote:

A useful addition, Gord
I have put it in my notes

Thanks,