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

There are a number of ways:
1) If you have nothing else in the column, us a formula such as =SUM(A:A)
2) If you are using Excel 2003, make the range a List (select range, use
Data | List)
3) Define a dynamic range name - see, for example
http://www.ozgrid.com/Excel/DynamicRanges.htm or
http://www.contextures.com/xlNames01.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ninko" wrote in message
...
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

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

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

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 -

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 -

Well, okay, you can do this to avoid cell G5:

=SUM(G1:G4)+SUM(G6:G65536)

Hope this helps.

Pete

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

- Show quoted text -

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/

Ok, thanks for everyones help.

Take care


Ninko



"Pete_UK" wrote:

Well, okay, you can do this to avoid cell G5:

=SUM(G1:G4)+SUM(G6:G65536)

Hope this helps.

Pete

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

- Show quoted text -