Thread: how do i keep a total down a column , ie. say start with
View Single Post
  #2   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 little more information about how things are laid out on your worksheet
would help us help you.

A possible start? Your original amount is in A1, the values to be
subtracted from that original amount are in column B. Then a formula like
=A1-SUM(B:B)
in cell A2 (or any cell not in column B) would show the current balance.

"julie" wrote:

i need to keep a running total down a column subtracting amounts from the
original figure
Reply With QuoteReply With Quote