+ 0 Votes Workaround Toivo Talikka 7 years ago Why don't you enter the daily number amount into the next cell and the formula in the first cell will then add what you have entered into the first cell?If you enter an amount into the cell where the formula is stored, you will overwrite the formula. + 0 Votes Try Paste Special waltjohnson35 4 years ago I'm not sure I understand what you need but this MAY be the answer.*Put the number you want to add into a cell. *Select the cell and Copy it.*Select the cell(s) you want to add to.*Select Edit > Paste Special > Add > OK*The object cell(s) have the total.This also works with Multiply, Subtract & DivideI hope this works for you.WaltJ + 0 Votes enable iterative calculation Philogos 4 years ago For this to work you need to enable iterative calculation and set the number of iterations to 1.Now place the formula =a1+b1 in cell b1.Anything you place in cell A1 will then be added to the total in b1. You will also want to set recalculation to manual so that the total is not updated each time an entry is made elsewhere in the worksheet.