Questions

Help

Tags:
+
0 Votes
Locked

Help

banaya57
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..
  • +
    0 Votes
    Toivo Talikka

    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
    banaya57

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

    +
    0 Votes
    Toivo Talikka

    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.

    +
    0 Votes
    waltjohnson35

    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

    +
    0 Votes
    Philogos

    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.

  • +
    0 Votes
    Toivo Talikka

    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
    banaya57

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

    +
    0 Votes
    Toivo Talikka

    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.

    +
    0 Votes
    waltjohnson35

    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

    +
    0 Votes
    Philogos

    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.