If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help with formula
Hi. I would like help with the following problem. A1 contains the total job
costs and is constantly being updated. At the end of the first invoice period I will type in the value from A1 into B1. Now on to my problem. For following invoice periods I would like to subtract previous invoices from the total job costs so that I only get the current invoice values. A1 Total job costs being continuously updated B1 At the end of two weeks I will type in the value from A1 C1 A1 minus B1 D1 A1 minus B1 and C1 E1 A1 minus B1 and C1 and D1 etc Is there a formula that I can insert into cell C1 and just copy down. I know that I could do this by typing in a unique formula into each cell, but I am just hoping there is an easier way to do this. My spreadsheet actually requires this process many times so any help you can send my way would be extremely appreciated. I hope I have explained the problem clearly enough. Gerd |
#2
|
|||
|
|||
Need help with formula
Hi,
In C1: =$A$1-SUM($B$1:B$1) -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Gerd" wrote: Hi. I would like help with the following problem. A1 contains the total job costs and is constantly being updated. At the end of the first invoice period I will type in the value from A1 into B1. Now on to my problem. For following invoice periods I would like to subtract previous invoices from the total job costs so that I only get the current invoice values. A1 Total job costs being continuously updated B1 At the end of two weeks I will type in the value from A1 C1 A1 minus B1 D1 A1 minus B1 and C1 E1 A1 minus B1 and C1 and D1 etc Is there a formula that I can insert into cell C1 and just copy down. I know that I could do this by typing in a unique formula into each cell, but I am just hoping there is an easier way to do this. My spreadsheet actually requires this process many times so any help you can send my way would be extremely appreciated. I hope I have explained the problem clearly enough. Gerd |
#3
|
|||
|
|||
Need help with formula
Thank you very much. Solved my problem. |
Thread Tools | |
Display Modes | |
|
|