Formula updating when rows are added on other sheet

**D-smoke** · 03-21-2013, 06:16 AM

Hello,
I want to know if it is possible for a formula to be updated when new rows are added on another sheet at the end of the rows included in the formula.

Attached example: If I add a row in Sheet1 under row 6, I want the formula in Sheet2 (cell B2) to update to

Please Login or Register  to view this content.

, but at the moment it stays as

Please Login or Register  to view this content.

Any ideas?Fomula updating when adding rows.xlsx

**Cheeky Charlie** · 03-21-2013, 06:24 AM

Put phase 1 and phase 2 in adjacent columns (i.e. B1 is Phase 2, B2=20, B3=54)
Then sum(sheet1!A:A)

**D-smoke** · 03-21-2013, 06:28 AM

Thanks for you reply,

The sheet I attached is only an example. The real sheet I am working with is much more complex and therefore it's not possible to apply you suggestion. Maybe there needs to be a script or something for this to work?