Adding in relative row
Posted on 2014-03-29
I am using the type of code:
"= Round(constants!AO" & i & ",constants!AP" & i & ")"
where I have many rows and need to keep track of what goes on in the relative row.
First I will explain just the simple problem and then in the end I need it in for the form above.
Simple problem: using units, or apples, or whatever. (Really the units are irreverent).
All numbers in the simple problem occur in row 10.
Suppose Column A has 24 apples. Column B has no Apples. Total number of Apples is 24 in Column C. Update.
Now suppose that we have 8 new apples in Column B so the total number of Apples in column C is 32. Update.
Now Column A has 32 apples, Column B, again has no Apples, and the Total in Column C is 32 apples. There are now 20 more applies in Column B. Update
Now in Column A has 52 apples, Column B has nothing and the Total in Column C is 52. Update.
i would also like to know how to "reset" this so that it would evaluate to "zero" in all columns and be ready to receive more data.
Now, this is all happening in one row and I need some mechanism so that it is this kind of form/notation so that this will update in whatever row it is referring to;
"= (constants!AO" & i & ",constants!AP" & i & ")"