I am having a problem with one of the simplest excel formulas. I am desperate for the answer: I am trying to enter a daily number amount into the same cell so that it will add what I put in with what's already in there.
Can somebody please help with this..
- Follow via:
- RSS
- Email Alert
Question
0
Votes
Answers (3)
0
Votes
Workaround
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.
If you enter an amount into the cell where the formula is stored, you will overwrite the formula.
3rd Mar 2007
Replies
So, there isn't a formula that you can lock into one cell to create an ongoing sum?
banaya57@...
3rd Mar 2007
A formula can add up a range of cells. You cannot overwrite a formula with a value. If you want to enter an amount into the same cell every time, rather than the next cell in a row or a column, you may have to look into programming some data entry macros in VBA.
Toivo Talikka
4th Mar 2007
0
Votes
Try Paste Special
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 & Divide
I hope this works for you.
WaltJ
*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 & Divide
I hope this works for you.
WaltJ
30th Nov 2009
0
Votes
enable iterative calculation
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.
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.
Updated - 1st Dec 2009
