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?

Sorry I'm not too good with Excel.

Thanks


Ninko



"Gord Dibben" wrote:

Ninko

=SUM(A1:INDEX(A:A,ROW()-1))


Gord Dibben MS Excel MVP

On Fri, 13 Jul 2007 13:04:00 -0700, Ninko
wrote:

Hi there,
I'm trying to perform a sum on a few rows, but when I add a new row I have
to update the range in the sum to have the new row included. Is there a way
to have the range update to include the new row(s)?

Hope that makes sense lol.

Thanks


Ninko