A formula for accruing values that are regularly deleted?

My apologies for the vagueness, but I was limited on space.

Basically, I'd like to have two different cells, one that can have values continuously added and deleted while having the total of all values added accrued into the second cell. This is for business purposes so that employees can continuously add their values for the day, then delete it so the next one can enter theirs.

Any help would be greatly appreciated.

OK, not 100% sure that I understand but here's an attempt
There's a small piece of VBA code in the ThisWorkbook object that performs the calculation.
The two cells are named "Value" and "Result" so that they can be placed anywhere on any sheet in the workbook.

How did you make it? How did you do this?

I'm not too experienced with Excel. Only had one class with Office in general.

Is it what you wanted?

Press Alt+F11 to open the Visual Basic Editor (VBE). To the left you will see a tree structure. Expand it and double click the ThisWorkbook object. Now you will see the code.
To name a cell or a range, simply select the desired cells and type the desired name in the little box to the left of the formula bar where the address of the cell is shown. To edit your names, select Formulas toolbar and then click Name Manager.

I recommend a visit to this site if you want an introduction to macros: http://www.excel-vba.com/excel-vba-s...-beginners.htm

Yes, that's exactly what I wanted, though I'm still having issues with getting the code to work for multiple cells.

Thanks for your help so far.

What's the problem?