Faz,

the OP will be simply entering the new value at the end of the column, and
not inserting a new row everytime.

Mangesh




"Faz" wrote in message
...

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