View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default how do i keep a total down a column , ie. say start with

A second possibility:
Original value in A2
First payment in B2
for initial balance, in C2 you could put = A2-B2

At this point you continue putting 'payments' in column B, and in C3 you put
this formula:
=C2-B3
and that will fill on down the sheet keeping a running balance for you.

"julie" wrote:

i need to keep a running total down a column subtracting amounts from the
original figure