I think I understand what you're facing....

It seems like you want to use formulas to create a numerical
sequence(1,2,3...), and you do that by adding 1 to the cell above the formula
cell, right? The problem occurs when you delete the referenced cell's row.
Example:
A10: =+SUM(A9)+1
--iF row 9 is deleted...the formula returns an error.

Here are some alternatives to that approach:

A10: =OFFSET(A10,-1,0)+1
(ALWAYS adds 1 to the value of the cell directly above the formula cell)
or
A10: =MAX($A$1:OFFSET(A10,-1,0))+1
(Adds 1 to the previous max value above the formula cell...allows for blank
cells in the referenced range)

Am I on the right track here?
Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Rere" wrote:

All I know how to do is enter info into a cell. This is a list of numbered
employees. Usually, I would just seleted the cell and delete, but I get
###error. The formula is =+sum (A73+1) Please help!!!