Thread: Running Totals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Running Totals

Hello...

I was wondering if there is a simple way to do maintain an updated
total in the same cell? What I mean is this:

Cell A1 Cell B1
Balance $5,000.00

Cell A4 Cell B4
Amount Added $1,000.00
Amount Added $1,000.00
Amount Added

Everytime that an amount is entered next to the 'Amount Added' field
(i.e. $1,000), then the amount in Cell B1 ($5,000) will increment by
the entered amount. I was not sure if this creates a circular
reference or not.

Thanks for any help on probably what is a simple solution... I am just
not seeing it.