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 |