Add this code to the sheet (right click the sheet tab and paste this code)

Private Sub Worksheet_Change(ByVal Target As Range)
Static dblLastValue As Double

If Target.Address = "$G$3" Then
Application.EnableEvents = False
Target.Value = dblLastValue + Target.Value
dblLastValue = Target.Value
Application.EnableEvents = True
End If
End Sub
--
HTH...

Jim Thomlinson


"Vicki" wrote:

I want to create a running total in g3. every time i enter a number in g3 it
will add to itself.


"JLGWhiz" wrote:

=2*2
Other than that, what specific type of calculation do you want to do?

"Vicki" wrote:

How do i calculate in one cell without creating a circular reference?