Per Mo Jan-07 Feb-07 Mar-07 Apr-07 May-07 Total
Value 32.50 32.50 32.50 32.50 32.50 162.50

This is part of the example of my work sheet, now I need to set the
automatically deduct the month fee from the total value each month.

I hope this will help you.



"Bernard Liengme" wrote:

You will need to elaborate on the question. Give details of how the data is
laid out in the worksheet, and exactly what you need.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jojo" wrote in message
...
How do you create automatically subtract the balance each month. We use 13
periods for a year.

"Bernard Liengme" wrote:

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.