Auto Increment formula issue

**robpopper** · 03-13-2013, 12:48 PM

I am trying to find a formula to auto increment a result when a (daily) new row is inserted into the workbook. Cell B2 is the starting point and I am comparing the value in the current row to B2. At the moment cell B5 accomplishes this objective. However when I insert an additional row, I have to manually adjust the formula. Can this be done automatically as there will be about 10 columns with this same issue. Thanks for any thoughts on the subject.

**rcm** · 03-13-2013, 01:08 PM

replace your sum() with

Please Login or Register  to view this content.

a7 being the row at which the formula is originally inserted

**robpopper** · 03-13-2013, 01:19 PM

rcm, Thank you for the fix, much appreciated. Works perfectly. the inserted row is actually A6, so your formula would read:
=SUM(INDIRECT("B"&ROW(A6)-1)-B$3).