formulas

[Guest]

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.

 

[Leo Heuser]

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