Deducting from a total!! HELP!!!!!!!!!!!!!
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 !!!! |
Deducting from a total!! HELP!!!!!!!!!!!!!
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 !!!! |
Deducting from a total!! HELP!!!!!!!!!!!!!
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 !!!! |
Deducting from a total!! HELP!!!!!!!!!!!!!
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 !!!! |
Deducting from a total!! HELP!!!!!!!!!!!!!
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 !!!! |
All times are GMT +1. The time now is 01:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com