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