Data Entry and Formulas

james · Jun 9, 2008

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 · Jun 9, 2008

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 · Jun 10, 2008

james said:
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.