Calculate Remaining Balance
 

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

Since the invoices are positive numbers and the payments are negative you
could just sum the Amount column. =sum(c2:c??)


"cindi" wrote in message
...
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

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