Data Entry and Formulas

[james]

Good afternoon folks, I'll try to keep this short. The formula i'm working with
=-sum(c6:h6)+a6, is in cell b6. ? how can I enter a new value in a6 and have
b6 display the total of both the existing b6 and new entry in a6. I'm sure
I'll
have many more ?'s but I'll start with this one first. To any one who writes
program
formulas for a living lets talk.

 

[Gord Dibben]

You can do what you want but anything based on accumulating in a cell is very
error-prone and next to impossible to trouble-shoot because there is no "paper
trail" to look back at.

But see John McGimpsey's site for a few methods.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben MS Excel MVP

 

[james]

Good afternoon folks, I'll try to keep this short. The formula i'm working with
=-sum(c6:h6)+a6, is in cell b6. ? how can I enter a new value in a6 and have
b6 display the total of both the existing b6 and new entry in a6. I'm sure
I'll
have many more ?'s but I'll start with this one first. To any one who writes
program
formulas for a living lets talk. In this case I will shout THANK YOU MR. DIBBEN.