A2 has client's name
B2:N2 has the monthly charges for first year
M2 has total yearly cost
So =M2-SUM(B2:N2) will give you the balance.
Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jojo" wrote in message
...
Can anyone help me, please!
I have a worksheet created as client contract agreement.
first column was the client name, start from second column is each month
pricing (the columns is base on the lenght of the contract, it is between
1
year to 3 years.), after the columns will the annual total price that
client
paid. But I want to create one column that it will automatically subtract
each month pricing from the annual total price.

For your infor. we use 13 periods a year instead of 12 periods.