I have a spreadsheet that contains a sum of multiple rows referenced from
another sheet (ex. sum(Input!B10:F12)). This formula is copied multiple
times with incremental changes in the formula (ex next formula is
sum(Input!B14:B16). I needed to add a row to each formula and I am wondering
if there is a fast way to increase the sum of each formula by 1 row (ex new
formula would read sum(input!B10:F13) and then sum(Input!B15:18). Any help
would be appreciated since it is a big spreadsheet and the thought of
retyping each formula is daunting.

Anita,

I would use the Replace command (ctrl-F, choose the Replace tab). You can
specify that all cells within a workbook or sheet be replaced with one click.
--
http://HelpExcel.com




"Anita D" wrote:

I have a spreadsheet that contains a sum of multiple rows referenced from
another sheet (ex. sum(Input!B10:F12)). This formula is copied multiple
times with incremental changes in the formula (ex next formula is
sum(Input!B14:B16). I needed to add a row to each formula and I am wondering
if there is a fast way to increase the sum of each formula by 1 row (ex new
formula would read sum(input!B10:F13) and then sum(Input!B15:18). Any help
would be appreciated since it is a big spreadsheet and the thought of
retyping each formula is daunting.

Thanks Galimi. I think I am still confused though. I am not sure how I
would use the replace command. I always thought of the find/replace command
is find everything that is "A" and change it to "B". Is there a way to
change a non-static formula to get it to increment by 1 extra row? Thanks
again for your help.

"galimi" wrote:

Anita,

I would use the Replace command (ctrl-F, choose the Replace tab). You can
specify that all cells within a workbook or sheet be replaced with one click.
--
http://HelpExcel.com




"Anita D" wrote:

I have a spreadsheet that contains a sum of multiple rows referenced from
another sheet (ex. sum(Input!B10:F12)). This formula is copied multiple
times with incremental changes in the formula (ex next formula is
sum(Input!B14:B16). I needed to add a row to each formula and I am wondering
if there is a fast way to increase the sum of each formula by 1 row (ex new
formula would read sum(input!B10:F13) and then sum(Input!B15:18). Any help
would be appreciated since it is a big spreadsheet and the thought of
retyping each formula is daunting.

Anita,

What is the driving force behind the change? The offset function is very
useful, especially if the scope of rows included in the range should change.
--
http://HelpExcel.com




"Anita D" wrote:

Thanks Galimi. I think I am still confused though. I am not sure how I
would use the replace command. I always thought of the find/replace command
is find everything that is "A" and change it to "B". Is there a way to
change a non-static formula to get it to increment by 1 extra row? Thanks
again for your help.

"galimi" wrote:

Anita,

I would use the Replace command (ctrl-F, choose the Replace tab). You can
specify that all cells within a workbook or sheet be replaced with one click.
--
http://HelpExcel.com




"Anita D" wrote:

I have a spreadsheet that contains a sum of multiple rows referenced from
another sheet (ex. sum(Input!B10:F12)). This formula is copied multiple
times with incremental changes in the formula (ex next formula is
sum(Input!B14:B16). I needed to add a row to each formula and I am wondering
if there is a fast way to increase the sum of each formula by 1 row (ex new
formula would read sum(input!B10:F13) and then sum(Input!B15:18). Any help
would be appreciated since it is a big spreadsheet and the thought of
retyping each formula is daunting.

Galimi -

Unfortunately I messed up when I was adding the rows and added them to the
bottom instead of in the middle of the sequence. I think I may just go back
and delete the added rows and add them back into the middle of the sequence
so the formula will automatically adjust. Thanks again for all your help. I
appreciate it!

"galimi" wrote:

Anita,

What is the driving force behind the change? The offset function is very
useful, especially if the scope of rows included in the range should change.
--
http://HelpExcel.com




"Anita D" wrote:

Thanks Galimi. I think I am still confused though. I am not sure how I
would use the replace command. I always thought of the find/replace command
is find everything that is "A" and change it to "B". Is there a way to
change a non-static formula to get it to increment by 1 extra row? Thanks
again for your help.

"galimi" wrote:

Anita,

I would use the Replace command (ctrl-F, choose the Replace tab). You can
specify that all cells within a workbook or sheet be replaced with one click.
--
http://HelpExcel.com




"Anita D" wrote:

I have a spreadsheet that contains a sum of multiple rows referenced from
another sheet (ex. sum(Input!B10:F12)). This formula is copied multiple
times with incremental changes in the formula (ex next formula is
sum(Input!B14:B16). I needed to add a row to each formula and I am wondering
if there is a fast way to increase the sum of each formula by 1 row (ex new
formula would read sum(input!B10:F13) and then sum(Input!B15:18). Any help
would be appreciated since it is a big spreadsheet and the thought of
retyping each formula is daunting.