Software·43,784 discussions

Help

Locked

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..

Topic

Clarifications

In reply to Help

Clarifications

Workaround

In reply to Help

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.

Excel Formula

In reply to Workaround

So, there isn’t a formula that you can lock into one cell to create an ongoing sum?

Ongoing sum

In reply to Excel Formula

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.

Try Paste Special

In reply to Help

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

enable iterative calculation

In reply to Help

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.

[Author]

Replies