Formula to add a new data entry to an existing number to get a new sum total

[Cquake]

I have looked around and can't seem to find the correct answer for this. Here is what I am trying to do. For help purposes I have created a chart with the following headings. I would like to be able to enter a production number in the today column that would automatically add that entry to the TOTAL column to get a new number and then clear out the TODAY column to enable to me to enter a new entry later to once again add to the TOTAL column. Any help would be greatly appreciated. The headings would be A1:D1. The TOTAL columns would then show 56, 54, 78, 74 after those entries.

NAME	DAYS	TOTAL	TODAY
John	5	31	25
Henry	4	27	27
Tom	8	55	23
Barbara	6	41	33

 

[Fluff]

You cannot do that with a formula, it would need to be VBA, is that ok?

 

[Cquake]

You cannot do that with a formula, it would need to be VBA, is that ok?

Yes that would be ok. Thanks for your help

 

[Fluff]

Ok, how about

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Column = 4 Then
      Application.EnableEvents = False
      Target.Offset(, -1).Value = Target.Offset(, -1).Value + Target.Value
      Target = ""
   End If
   Application.EnableEvents = True
End Sub

This needs to go in the relevant sheet module & will update col C whenever you enter a value in col D.
This only works if you change the cells in col D individually.

 

[Cquake]

Thank you as that works perfectly.

 

[Fluff]

You're welcome & thanks for the feedback.