I believe you are seeing ### because the cell is not large enough to
display the #REF! error. When you delete the cell (A73), either by
right clicking and seleting delete or by using the Edit function, the
formula no longer knows what cell to reference, and all the other cells
below the one with the error have all adjusted accordingly (in this
case, up one). If you look below the cell with the error, you will see
that it now has =+sum(A73+1).

You may either delete the cell with the error also, or you will need to
select the cell and change the portion of the formula with the #REF! to
A73 again. If you choose that option you will need to fill the
remaining cells with the updated formula. Another option is to delete
the entire row to maintain the function's integrity.

If this does not help, please reply with a bit more information.


--
surg4u1975
------------------------------------------------------------------------
surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718
View this thread: http://www.excelforum.com/showthread...hreadid=496414