Since you enter payment with negative values you can just sum the amount column
=SUM(C2:C10)
Regards,
Peo Sjoblom
"cindi" wrote:
I need to create a formula that refers to a remaining
balance. The form is a Account Statement and has the
following columns:
Date Transaction Amount Balance
1/2/04 Inv.# 123 89.23 89.23
1/10/04 Inv.# 124 50.87 140.1
1/21/04 PMT -60.00 80.10
Amt. Due ?????
How do have excel automatically calculate the amount
due? Any help would be greatly appreciated.
Thanks!
Cindi
|