Sadly yeah, otherwise it will be all over the place.


Ninko



"Pete_UK" wrote:

You can do:

=SUM(G6:G65536)

Do you really need to include the cells G1:G4 as part of the sum?

Hope this helps.

Pete

On Jul 14, 12:32 am, Ninko wrote:
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- Hide quoted text -

- Show quoted text -