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.

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.

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.

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.

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.

If the first five numbers are in A2:E2 and 162.50 is in F2 then
=F2-SUM(A2:E2) will give total less sum of months.
Why do you keep saying 'automatic' - Excel recalculates formulas when data
is changed unless you have change it not to do so.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

What I am trying to do is the total value will deduct the month charges at
each month. I want to set up it generate auto without me going in to the work
sheet to subtract the amount. Will excel do it.


"Bernard Liengme" wrote:

If the first five numbers are in A2:E2 and 162.50 is in F2 then
=F2-SUM(A2:E2) will give total less sum of months.
Why do you keep saying 'automatic' - Excel recalculates formulas when data
is changed unless you have change it not to do so.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

Hi Bernard,
The formular you gave me does help but I don't want to subtract the value
manually, I want to set it up it subtract the amount every 30 days. Because I
have 1 big clients list.

I really appreciate your help.



"Bernard Liengme" wrote:

If the first five numbers are in A2:E2 and 162.50 is in F2 then
=F2-SUM(A2:E2) will give total less sum of months.
Why do you keep saying 'automatic' - Excel recalculates formulas when data
is changed unless you have change it not to do so.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

If you enter the data every 30 days then that is when it will calculate
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jojo" wrote in message
...
Hi Bernard,
The formular you gave me does help but I don't want to subtract the value
manually, I want to set it up it subtract the amount every 30 days.
Because I
have 1 big clients list.

I really appreciate your help.



"Bernard Liengme" wrote:

If the first five numbers are in A2:E2 and 162.50 is in F2 then
=F2-SUM(A2:E2) will give total less sum of months.
Why do you keep saying 'automatic' - Excel recalculates formulas when
data
is changed unless you have change it not to do so.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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