Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
I'm creating a resource allocation workbook. My first tab is the overall
estimate. The sub sequential tabs break up the data by quarter. I would like to change the formula (=SUM('Q1 HQ'!I4:I14)/100 ) on the estimate tab so that when I add a row to the subsequent tabs (in this case - Q1 HQ), the formula will recognize that I added another row with that same value (in this case the value is "HQ" and not a number: e.g. adding a I15 row with the same HQ value without having to change my overall formula). Basically, would like the formula to automatically recognize an additionally row added with the same HQ value without having to update the formula each time. As shown above I have created the sum formula. I'm just not sure how to change it so it automatically recognizes an additional row was added. Any help is much appreciated!!! I hope that made sense...I'm not good at Excel lingo. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
"cachegirl68" skrev i en meddelelse
... I'm creating a resource allocation workbook. My first tab is the overall estimate. The sub sequential tabs break up the data by quarter. I would like to change the formula (=SUM('Q1 HQ'!I4:I14)/100 ) on the estimate tab so that when I add a row to the subsequent tabs (in this case - Q1 HQ), the formula will recognize that I added another row with that same value (in this case the value is "HQ" and not a number: e.g. adding a I15 row with the same HQ value without having to change my overall formula). Basically, would like the formula to automatically recognize an additionally row added with the same HQ value without having to update the formula each time. As shown above I have created the sum formula. I'm just not sure how to change it so it automatically recognizes an additional row was added. Any help is much appreciated!!! I hope that made sense...I'm not good at Excel lingo. If you by adding another row mean inserting a new row here's one way: =SUM('Q1 HQ'!I4:OFFSET('Q1 HQ'!I15,-1,0))/100 -- Best regards Leo Heuser Followup to newsgroup only please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |