Advanced: 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
 
in B1:
=SUM(OFFSET(B1,0,-1),5)

and in C1:
=SUM(OFFSET(C1,0,-1),5)

The offset says stay in the same row, but go left one column.
 
Back
Top