software

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: www.excelforum.com/member.php...oamp;userid=29874
View this thread: www.excelforum.com/showthread...hreadid=495779Hi KARIM,

See

www.mcgimpsey.com/excel/accumulator.html

--
Kind regards,

Niek Otten

quot;KARIMquot; gt; wrote in
message ...
gt;
gt; I need a totalizer formula?
gt;
gt; example : A number is put daily in A1, then auto transfered to A2
gt; Next day a new number entred in A1 will be
gt; accumulated
gt; in A2.( A2 is considred as accumulator or
gt; integrator)
gt;
gt; thanx for help.
gt;
gt;
gt; --
gt; KARIM
gt; ------------------------------------------------------------------------
gt; KARIM's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29874
gt; View this thread: www.excelforum.com/showthread...hreadid=495779
gt;
Karim

If you quot;mustquot; have an accumulator cell, check this thread out before
proceeding.

snipurl.com/8e64Gord Dibben Excel MVP

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

gt;
gt;I need a totalizer formula?
gt;
gt;example : A number is put daily in A1, then auto transfered to A2
gt;Next day a new number entred in A1 will be
gt;accumulated
gt;in A2.( A2 is considred as accumulator or
gt;integrator)
gt;
gt;thanx for help.

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

Thanks,

--
Kind regards,

Niek Otten

quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
news
gt; Karim
gt;
gt; If you quot;mustquot; have an accumulator cell, check this thread out before
gt; proceeding.
gt;
gt; snipurl.com/8e64
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt; On Fri, 23 Dec 2005 10:06:47 -0600, KARIM
gt; gt; wrote:
gt;
gt;gt;
gt;gt;I need a totalizer formula?
gt;gt;
gt;gt;example : A number is put daily in A1, then auto transfered to A2
gt;gt;Next day a new number entred in A1 will be
gt;gt;accumulated
gt;gt;in A2.( A2 is considred as accumulator or
gt;gt;integrator)
gt;gt;
gt;gt;thanx for help.

Thankx A Lot For Help--
KARIM
------------------------------------------------------------------------
KARIM's Profile: www.excelforum.com/member.php...oamp;userid=29874
View this thread: www.excelforum.com/showthread...hreadid=495779
Thankx A Lot For Help--
KARIM
------------------------------------------------------------------------
KARIM's Profile: www.excelforum.com/member.php...oamp;userid=29874
View this thread: www.excelforum.com/showthread...hreadid=495779Thanks Nick

quot;Accumulatingquot; 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(quot;A1quot;)) Is Nothing Then Exit Sub
With Target
If .Value lt;gt; quot;quot; Then
ActiveSheet.Cells(Rows.Count, quot;Bquot;).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 quot;View Codequot;. 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 quot;paper trailquot; 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, quot;Niek Ottenquot; gt; wrote:

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