| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help creating continuously calculating and updating formula
I'm not sure if I'm asking this correctly, so please help me clarify if needed!
first example: =SUM(AI49:AN49)-SUM(AI48:AN48) in which "AN" is regularly extended (AO, AP, etc.). How can I create a formula that gives me an answer when cell 49 is standard and cell 48 is continuously updating? Currently, I am manually changing "AN" to "AO", and so on as I update the information. second example: =SUM(AI48:AN48)/SUM(AI49:AN49) with the same situation as above. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CREATING FORMULA FOR CALCULATING ENDING BALANCE WITH PMT AND INTRE | Excel Worksheet Functions | |||
| Issue with the Camera Button for creating dynamically updating pic | Excel Discussion (Misc queries) | |||
| Creating auto Updating Pivot Table linked to external data. | Excel Discussion (Misc queries) | |||
| How do I create a formula that continuously numbers my invoices? | Excel Worksheet Functions | |||
| how to: continuously updating column in new worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
