sequencial cell numbers w/ an Exception

  • Thread starter Thread starter Sharron
  • Start date Start date
S

Sharron

Ok I read the previous post about sequencial numbers but how can I set
up the numbering so that it all ways add the contents of the previous
cell, regardless of what the cell name is.

I use the normal process for creating sequential numbers but when I
insert a new row w/i the group the sequence is broken.

Is there a way to say

A1 = 5.0
B1 = SUM(PREVCELL + 5);
C1 = SUM(PREVCELL + 5);

instead of

A1 = 5.0
B1 = SUM(A1 + 5);
C1 = SUM(B1 + 5);

As you can see that if a new cell is inserted into the later it breaks
but the earlier statment still holds true.

Any ideas?

Thanks in advance
 
Sharron

in cell B1 put: =SUM(OFFSET(B1,,-1)+5) and drag across. If you insert
a column, drag the formula over it

Regards

Trevor
 
Wow that works, I would do that across rows by inputing

in cell A2 I put: =SUM(OFFSET(A2,-1,)+5)

Thanks
 
Back
Top