In article ,
"Bill" wrote:

Are you talking about the macro that performs the task or the
"Worksheet Function Accumulator."

Both will work.

If you are talking about the latter, how do I keep the whole sheet
from calculating I make a change on the sheet? I could not get the
macro to work as written.

hard to tell - what does "I could not get the macro to work" mean? The
macro works fine for the example given. How did you modify it? Did you
put it in the worksheet code module?