Fri, 13 Jul 2007 16:32:02 -0700 from Ninko
:
Thanks for the help, one other question though. On one colunm I'm using:
=SUM(G:G) but the answer is in cell G5 and so it gives an error, is there a
way of getting around this, like ignore that cell or something?

Leave G5 blank, and in G6 put this formula
=sum(G1:G5)
Then insert rows above row 5 to add numbers. The formula will update
automatically.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/