View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Adding entry in one cell to a running total in another cell

Possible but not recommended.

How would you audit for errors?

See JE McGimpsey's site for methods.

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


Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 14:53:01 -0700, TommyB
wrote:

Is it possible to enter a number in cell A1 and have it added to a number
that already exists in cell A5 and the new total replaces the current total
in A5?