keep a record?

[misterio38]

hello

i wonder if any of you could help me

i need a formula in a cell that can "remember" or "keep a record" and sum the values that changes in other cell

example
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

then[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
then
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]0[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
then
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

etc

please it would help me a lot
and it would be great if it was a formula and not vba
i still dont know to use that

thank you

 

[Eric W]

Re: keep a record? (new in excel please help)

You can't do that with native Excel formulas. You need VBA. If you want to try that, open a copy of your workbook. Right click on the sheet tab on the bottom and select View Code. Paste this code in the window that opens:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$A$1" Then [B1] = [B1] + [A1]
End Sub

B1 is where you want the sum to go, A1 where the number to add will go. Change as needed. Close the VBA editor with Alt-Q. Try it out. Let us know if this works for you.

 

[misterio38]

Re: keep a record? (new in excel please help)

sorry to bother you but
im not sure what im doing
i tried that but nothing happens
do i have to press the "play" icon? (i did)
if its not to much to ask can you gimme a tutorial link to explain what im doing wrong
than you

 

[misterio38]

Re: keep a record? (new in excel please help)

sorry
i just find how to do it
sorry it works great
thanks for the help
sorry