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

	1		1

<tbody>
</tbody>

then

	2		3

<tbody>
</tbody>

then

	0		3

<tbody>
</tbody>

then

	1		4

<tbody>
</tbody>

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