That's only possible with VBA. This code needs to code on a sheet, it will watch what is entered into A1 and add to it each time you make a change.

Right-Click on Sheet name
Choose VIEW CODE
Paste in Code
Alt-F11 to close VBEditor
Save sheet
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Static MyCell As Double

Application.EnableEvents = False
    With Target
         If Not Application.Intersect(Target, [A1]) Is Nothing Then
            
            If Not IsEmpty(.Value) And IsNumeric(.Value) Then
                MyCell = MyCell + .Value
                Else
                MsgBox "The entry in this cell must be numbers only!", vbExclamation, "Wrong Entry"
                .Select
            End If
               .Value = MyCell
        End If
    End With
Application.EnableEvents = True
End Sub
The colored part could be duplicated to set up a second cell to watch...perhaps A2. Just change the MyCell references to MyCell2 in the added section, and insert a Static MyCell2 reference at the top, too.

Play around with it.