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