Maintaining Formula after adding a new row


I have a formula that adds data in a column. =SUM(A5:A10). The problem
is that every time I copy a new row and insert it at row 5, my formula
changes to =SUM(*A6*:A10). I just want it to stay the same. I've
tried using an absolute value $A$5, but it still changes when a new row
is added. I've tried using a named reference as well as locking, but my
merged cells caused some problems with the lock.


--
shaught
------------------------------------------------------------------------
shaught's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30802
View this thread: http://www.excelforum.com/showthread.php?threadid=504625

.

Relevant Pages

  • Re: Averaging every other cell
    ... I had to lock my reference cells, ... asluiter's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24577 ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: change...
    ... The only way to truly lock in the value of a formula is to replace it with ... If you change calculation mode to manual (Tools, Options, ... | alen_re's Profile: ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Profiling multithreaded C++ code
    ... >> connection is in use during the call to shutdown. ... single-threaded profile. ... you're holding a lock for too long if that lock is uncontended. ... many interaction optimizations are local pessimizations. ...
    (comp.os.linux.development.apps)
  • [AppArmor 42/45] AppArmor: add lock subtyping so lockdep does not report false dependencies
    ... AppArmor uses lock subtyping to avoid false positives from lockdep. ... A third lock type is given to the profile lock ... +AppArmor uses lock subtyping to avoid false positives from lockdep. ...
    (Linux-Kernel)
  • Re: Hmmm password problem
    ... The Viral infection created a grid lock and some of your registry ... How to Identify a Damaged User Profile and Create a New Profile ... screensaver go to welcome screen I can't log back in. ... I'll test out functions in safe mode(welcome screen in safe if ...
    (microsoft.public.windowsxp.help_and_support)