Increment A2 from A1 and A2 Sum

[jpor]

I have two cells:
A1 - manual value
B1 - automatic increment = B1 + A1

How can i make it?
(=error: circular reference)

Note: I have this formula repeated in some lines:
= B2 + A2
= B3 + A3
...

 

[Niek Otten]

It is not clear to me what you are trying to achieve. If B1 = x, it can not
at the same time be x+A1.
Can you give an example?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Jerry W. Lewis]

You cannot have B1 accumulate the sum of all values that have ever
appeared in A1 with a worksheet formula. You could write a macro tied
to the worksheet change event that would do it, but that is generally
unadvisable:
- How do you correct it if there was an erroneous entry in A1?
- You would have no history from which to verify a particular value in B1.

Jerry

 

[Randall Roberts]

Change your formula to read =a1+(enter the increment value here)
then it will work for you

 

[Earl Kiosterud]

jpor,

I think you want to be able to put values in A1, and have B1 accumulate
them. This may not be a good solution, in that you have no way of knowing
what has been accumulated ("Did I put this particular item in yet, or
not?"). B1 eats them up. It's better to list your values in a column and
use something like =SUM(A2:A50) or whatever. And there should be a label of
some kind in an adjacent column to identify the entries.

But if you insist on your accumulator approach, use Tools - Options -
Calculation, and select "Iteration." Set the max iterations to 1. To reset
B1 to 0, put in a negative value equal to what's currently in it.

 

[Earl Kiosterud]

Oops. To reset the total, put a value equal to the current total but
negative into A1, not B1.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

jpor,

I think you want to be able to put values in A1, and have B1 accumulate
them. This may not be a good solution, in that you have no way of knowing
what has been accumulated ("Did I put this particular item in yet, or
not?"). B1 eats them up. It's better to list your values in a column and
use something like =SUM(A2:A50) or whatever. And there should be a label of
some kind in an adjacent column to identify the entries.

But if you insist on your accumulator approach, use Tools - Options -
Calculation, and select "Iteration." Set the max iterations to 1. To reset
B1 to 0, put in a negative value equal to what's currently in it.