Deducting from a total!! HELP!!!!!!!!!!!!!

[DestinySky]

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]

With 15000 in say A1:

=A1-SUM(B1:G1)

B through G is 6 columns. Adjust as needed.

HTH,
Paul

 

[DestinySky]

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?

 

[DestinySky]

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

 

[Peo Sjoblom]

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