Yes there is a way, i just figured out how to do it myself!

If you have an equation that sums an entire column like =SUM(A1:A50)
and you need it to keep updating, just insert a row within the range of
rows 1 to 50, and the formula will automatically update to =SUM(A1:A51)


--
Faz
------------------------------------------------------------------------
Faz's Profile: http://www.excelforum.com/member.php...o&userid=27830
View this thread: http://www.excelforum.com/showthread...hreadid=474043