I have a spreadsheet with 8 rows and 6 columns. At the end of each row is a
dollar amount. I will need the cells in each row to deduct from that rows
dollar amount.
EX.
Customer week 1 week 2
week3 total
ABC Customer $500.00 $300.00 $600.00
15000.00

what formula would I need to use to deduct the 500.00, 300.00 and 600.00
from the 15000.00??

THANKS !!!!

With 15000 in say A1:

=A1-SUM(B1:G1)

B through G is 6 columns. Adjust as needed.

HTH,
Paul

--

"DestinySky" wrote in message
...
I have a spreadsheet with 8 rows and 6 columns. At the end of each row is a
dollar amount. I will need the cells in each row to deduct from that rows
dollar amount.
EX.
Customer week 1 week 2
week3 total
ABC Customer $500.00 $300.00
$600.00
15000.00

what formula would I need to use to deduct the 500.00, 300.00 and 600.00
from the 15000.00??

THANKS !!!!

How can I tally the deduction in the total cell... in other words.. how can I
have the 15000.00 do a deduction tally as amounts are entered in the other
cells?

"PCLIVE" wrote:

With 15000 in say A1:

=A1-SUM(B1:G1)

B through G is 6 columns. Adjust as needed.

HTH,
Paul

--

"DestinySky" wrote in message
...
I have a spreadsheet with 8 rows and 6 columns. At the end of each row is a
dollar amount. I will need the cells in each row to deduct from that rows
dollar amount.
EX.
Customer week 1 week 2
week3 total
ABC Customer $500.00 $300.00
$600.00
15000.00

what formula would I need to use to deduct the 500.00, 300.00 and 600.00
from the 15000.00??

THANKS !!!!

PCLIVE!! thanks!!! I answered my own question!!! You explanation helped me
figure it out!!



"PCLIVE" wrote:

With 15000 in say A1:

=A1-SUM(B1:G1)

B through G is 6 columns. Adjust as needed.

HTH,
Paul

--

"DestinySky" wrote in message
...
I have a spreadsheet with 8 rows and 6 columns. At the end of each row is a
dollar amount. I will need the cells in each row to deduct from that rows
dollar amount.
EX.
Customer week 1 week 2
week3 total
ABC Customer $500.00 $300.00
$600.00
15000.00

what formula would I need to use to deduct the 500.00, 300.00 and 600.00
from the 15000.00??

THANKS !!!!

Are you saying that you want to subtract each time a new value is entered in
one of those cells?


If so you would need code

http://www.mcgimpsey.com/excel/accumulator.html


of course this example adds the values you need to change it so it subtracts


--


Regards,


Peo Sjoblom



"DestinySky" wrote in message
...
How can I tally the deduction in the total cell... in other words.. how
can I
have the 15000.00 do a deduction tally as amounts are entered in the other
cells?

"PCLIVE" wrote:

With 15000 in say A1:

=A1-SUM(B1:G1)

B through G is 6 columns. Adjust as needed.

HTH,
Paul

--

"DestinySky" wrote in message
...
I have a spreadsheet with 8 rows and 6 columns. At the end of each row
is a
dollar amount. I will need the cells in each row to deduct from that
rows
dollar amount.
EX.
Customer week 1 week 2
week3 total
ABC Customer $500.00 $300.00
$600.00
15000.00

what formula would I need to use to deduct the 500.00, 300.00 and
600.00
from the 15000.00??

THANKS !!!!